tXMLMap - part without loop and part with loop

[KevSan]

Hi everybody,

I would like to transform one XML (XML.png) into a positional file by using some XML tag (without loop -> <Site> and <Orderdetails> before <OrderLine>) and some XML tag within a loop (<OrderLine>).

Unfortunately, I'm stuck. I can extract the unloop information I want but I do not know how to get the expected result (ExpectedResult.PNG).

You can find my tFileInputXML and my tXMLMap in the uploaded files.

Can someone please help me for this?

Have a nice day.

[Anonymous]

Hi

What is the result you are getting now? Can't read data from <site> tag?

Regards

Shong​

[KevSan]

This is what I get ...

Information from Site Tag and OrderDetails Tag are repeated -> but I don't want 😞

Do you know what I can do for my problem?

Regards.

[Anonymous]

write the first line to a new file, then append the second line to existing file, finally, append the records in loop tag to the existing file. The job looks like:

tFileInputXML--main--tHashOutput1(cache all data in memory for used later)

|onsubjobok

tHashInput1--tMap--tFileOutputDelimited1

|onsubjobok

tHashInput2--tMap--tFileOutputDelimited2 (append the second line to existing file created by tFileOutputDelimited1)

|onsubjobok

tHashInput3--tMap--tFileOutputDelimited3 ((append the records in loop tag to existing file created by tFileOutputDelimited1)

tHashInput1,2,3: read the required columns from tHashOutput1.

Hope it helps.

Regards

Shong

[KevSan]

Hi @Shicong Hong​ , I understand the principles but unfortunatley tHashOutput is not in my version.

How can I do so ?

Thanks for your time !