Do not change the html schema from input to output.

Highlighted
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.

Forteen 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??

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now