[Date Prev] [Date Next] [Prev in Thread] [Next in Thread] [Date Index] [Thread Index]

Re: Converting xml to table output


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.


2017-12-27 5:05 GMT+01:00 Shivanand Jeerigiwad <shivanand.jeerigiwad@gmail.com>:

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="" strict="false" classname="BMC_SoftwareServer">


            <attribute name="Serial Number" value="Test"/>

            <attribute name="Name" value="test"/>

            <attribute name="ShortDescription" value="test"/>




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.


+91 9986985798

ARSList mailing list