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

Converting xml to table output

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