Hi, You can use the " step. It can parse both XML files or XML documents in a stream.
Look at the GetXMLData examples in the .....\ARSystem\diserver\data-integration\samples\transformations directory. -- J 2017-12-27 5:05 GMT+01:00 Shivanand Jeerigiwad < [email protected]>: > Hi team, > > > I have a requirement to convert xml input to database table. However my > xml is not direct to process. Format is as below. > > Can anybody help me how to use such xml? > > > > <ci cooked="true" action="merge" strict="false" > classname="BMC_SoftwareServer"> > > <attributes> > > <attribute name="Serial Number" value="Test"/> > > <attribute name="Name" value="test"/> > > <attribute name="ShortDescription" value="test"/> > > </attributes> > > </ci> > > > > In this xml the attribute name will be field names e.g. Serial Number = > column 1 , Name = Column2 etc etc. > > > > Value will be value field for those columns. I need to push these values > to a table. > > > > Using Pentaho client 6.0.1 > > Let me know if you need more information. > > > Regards, > > Shiva > +91 9986985798 <+91%2099869%2085798> > > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist > >
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
