adding multiple rows to nested xml

Anonymous — Sat, 16 Nov 2024 07:46:58 GMT

Hi there,

I try to get this working for some time and don't reach my target so I hope to get some input by you 🙂

I have an existing XML which i manipulate in an thMap to adjust XML Tags etc. and now i would like to add different Values from row to two nested Tags.

looks like this:
tFileInputXML -- (document) -- thMap -- (document) ... what ever has to be done to get this work .... (document) -- tFileOutputXML

the XML from the ThMap output is like this (short Version):

<Output >
  <products>
    <client_uid></client_uid>
    <attrs>
      <name></name>
      <value></value>
    </attrs>
    <attrs>
      <name></name>
      <value></value>
    </attrs>

and now I have rows which should get into those attrs/name and attrs/value tags (add them on the end of those existing attrs tags).

So i have a row with the client_uid (to match with those from thMap output) and then a String like "Structure1" and its Value from another row "blabla1", then "Structure2" and the second "blabla2" how can i get that into the existing tags with max performance? (i did some workaround stuff and the job was going like 3h -.-)

i thank you already for reading this and sorry if this question was already answered (i was searching for days but maybe i just didn't search the right keywords)

Ps. in Attachment some pix from the Job may give you a better overview 🙂

Greetings

Slechtvalker

topic adding multiple rows to nested xml in Talend Studio

adding multiple rows to nested xml