AnsweredAssumed Answered

Converting Xml into table output

Question asked by Shivanand Jeerigiwad on Dec 26, 2017
Latest reply on Dec 28, 2017 by Diego Mainou

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.

Outcomes