Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Load XML file into MySql : Only Get One Row

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.

 

 

Labels (4)
1 Reply
tnewbie
Creator II
Creator II

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