topic Re: Load XML file into MySql : Only Get One Row in Talend Studio

Load XML file into MySql : Only Get One Row

Anonymous — Sat, 16 Nov 2024 03:42:50 GMT

Hello everyone,

Here's the thing, i have those 2000 XML files to put in my db.

It's running perfectly (thanks to this community's forum) except for one thing : i only get the first row of each file.

I saw someone having a similar problem on this forum and the answer was that his file wasn't clearly structured.

Is it the same thing with mine ?

And if yes, do you have a solution that doesn't imply me modifying each of the 2000 files manually ?

Can someone have a look and help me please ?

Thank you.

Re: Load XML file into MySql : Only Get One Row

tnewbie — Sat, 28 Dec 2019 03:47:50 GMT

RoParizot,

When you say multiple records, i assume you are talking about <votant> (as an example), not sure what your job design is and how you are carrying forward the xml data elements, if you are using tXMLMap, then you have to set ' asloop element' for each of the nodes that you want to iterate/loop(refer to #1 in the attached pic), accordingly in your output table in the tXMLMap you can add the 'set loop function' (refer to #2 in the attached pic) and that will do the magic.

Hope the attached pic helps you better...

xml iteration.png