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

Re: Converting xml to table output



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

        <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


--
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist