topic Extract data and create delimited file from a XML feed in Talend Studio

Extract data and create delimited file from a XML feed

Anonymous — Tue, 29 Oct 2019 18:05:01 GMT

HI,

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

input data:

<CD>

</CD>

<CD>

</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 — Wed, 30 Oct 2019 03:54:13 GMT

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

Anonymous — Mon, 04 Nov 2019 04:44:16 GMT

Thanks Sujay. Able to extract the data.