Extract data and create delimited file from a XML feed

[Anonymous]

HI,

I am having problem in extracting data from a XML file. Below is the use case

input data:

<AB>ABC012</AB>

<CD>

<CD1>12345</CD1>

<CD2>MF156</CD2>

</CD>

<CD>

<CD1>98765</CD1>

<CD2>MF558</CD2>

</CD>

</DE>

Expected Output:

record#1: ABC012~12345~MF156

record#2: ABC012~98765~MF558

Basically i would like to extract data for the tags where the tags are being repeated. In the above case tag under <CD> being repeated twice.

Please advise.

Thanks,

Brat

[Sujay1]

hi @BratB  please see the below screenshot it gives ur desired result. 

[Anonymous · Accepted solution]

Thanks Sujay. Able to extract the data.