Four Stars

Do not change the html schema from input to output.

Hi,

I have a problem with XMLfile.

I have a XML file constituted by 3 loops at the same level (as you can see in the picture). When i try to do the file import by using the componente tFileInputXML I import the same schema of it, but I can choose only one loop. How can I select all three loops?? How can create another XML file that has the same schema of that one of the input??

 

Thanks a lot.

 

 

XML.jpg.

  • Big Data
  • Data Integration
2 REPLIES
Seven Stars

Re: Do not change the html schema from input to output.

Idea of tFileInputXML - produce flat data, for this reason it accept only single Loop

 

You can parse each Loop separate, or  

You can read data as single row (type Document) and then parse all 3 loop in tXMLMap

 

Screen Shot 2017-05-05 at 10.17.13 AM.png

 

Don't forget not only define loops in Source, but as well define Source Loop for Target flow

-----------
Four Stars

Re: Do not change the html schema from input to output.

Hi, 

thanks for answer, but I don't understand. I have to import the file xml with tFileInputXML (with a single loop) and then I use tXMLMap but to create the file output I use tFileOuptputXML and it wants the row tag. Can send me the job flow process please??