Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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...