AnsweredAssumed Answered

How to map complex xml files to a 2d table as automaticly as possible.

Question asked by Maciej Wanicki on May 15, 2018
Latest reply on May 15, 2018 by Gotn O'Guts

I'm trying to use spoon for some data transformations. The imput file I need to work on is a complex xml file with multiple nodes that have multiple child nodes. The first step of the process I want to do is to just map it into a 2d table. For example:

 

<product>

     <id>1</id>

     <name>car</name>

     <attributes>

          <attribute>

               <id>1</id>

               <language>eng</language>

                    <name>speed</name>

                    <content>50mph</content>

               <language>pl</language>

                    <name>predkosc</name>

                    <content>60km/h</content>

          </attrubute>

          <attribute>

          ....

          </attribute>

     ...

     </attributes>

<product>

 

This is a simplified example. Actualy Attributes are a part of attribute group, each group is divided into languiages. I also have characteristics fields etc. How to tackle this problem ?

Outcomes