[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">

        <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