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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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