topic pivot in Data mapper in Talend Studio

pivot in Data mapper

kmrprvn — Mon, 27 Aug 2018 10:14:35 GMT

Hi All,

Can anyone help me to solve below scenario using data mapper. using data mapper because source XML contains multiple loops

Source - XML

Target - JSON

source element:

<ref_field>name,a,id,20,city,z</ref_field>

target :

name,id,city

a,20,z

Thanks in advance. let us know if anything required

Anonymous — Mon, 03 Sep 2018 03:58:33 GMT

Hello,

Would you mind posting your sample XML file which contains multiple loops on forum?

Best regards

Sabrina

jonlar — Sat, 20 May 2023 11:47:59 GMT

anyone ever find the answer to this?

Thanks

Anonymous — Wed, 24 May 2023 05:36:27 GMT

Hello @Laroche Jonathan

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina