topic tXMLMap missing data for few rows in Talend Studio

tXMLMap missing data for few rows

PS41 — Fri, 15 Nov 2024 21:40:51 GMT

I have the below XML format from tRestClient and trying to extract Journal, WorkdayID & Combined_Purchase_Orders column. I get all the data for Journal & WorkdayID column but missing only few in

Combined_Purchase_Orders column. Played around loops but nowhere successful with this. I also have few more elements which are at the next node level which are all coming up as empty.

Re: tXMLMap missing data for few rows

anselmopeixoto — Thu, 15 Jun 2023 00:39:56 GMT

Hi @Poorvi S

Have you tried putting the loop on both Journal, WorkdayID & Combined_Purchase_Orders elements?

Re: tXMLMap missing data for few rows

PS41 — Thu, 15 Jun 2023 08:31:21 GMT

hi @Anselmo Peixoto

Tried the above and is just repeating all the values in Combined_Purchase_Orders for each of Journal & WorkdayID and duplicating rows.

Re: tXMLMap missing data for few rows

anselmopeixoto — Thu, 15 Jun 2023 13:40:03 GMT

Hi @Poorvi S

Could you share a sample of the XML?

Re: tXMLMap missing data for few rows

PS41 — Thu, 15 Jun 2023 14:33:35 GMT

<wd:Report_Entry>

<wd:Journal wd:Descriptor="Journal-1">

<wd:ID wd:type="WID">990c0000</wd:ID>

</wd:Journal>

<wd:WorkdayID>99340001</wd:WorkdayID>

<wd:Operational_Transaction wd:Descriptor=" PI-1001746 - XYZ">

<wd:ID wd:type="WID">9904b07082a5901b1ba55ffaf46e0000</wd:ID>

</wd:Operational_Transaction>

<wd:Combined_Purchase_Orders wd:Descriptor="PO-100371">

<wd:ID wd:type="WID">4670000</wd:ID>

<wd:ID wd:type="Document_Number">PO-100371</wd:ID>

<wd:ID wd:type="Purchase_Order_Reference_ID">PURCHASE_ORDER-6</wd:ID>

</wd:Combined_Purchase_Orders>

<wd:Combined_Purchase_Order_Lines wd:Descriptor="PO-100371 - Line 2">

<wd:ID wd:type="WID">764bd0001</wd:ID>

<wd:ID wd:type="Line_Number" wd:parent_type="WID" wd:parent_id="9900000">2</wd:ID>

<wd:ID wd:type="Line_Number" wd:parent_type="Document_Number" wd:parent_id="PO-100371">2</wd:ID>

<wd:ID wd:type="Line_Number" wd:parent_type="Purchase_Order_Reference_ID" wd:parent_id="PURCHASE_ORDER-6">2</wd:ID>

</wd:Combined_Purchase_Order_Lines>

</wd:Report_Entry>

Re: tXMLMap missing data for few rows

anselmopeixoto — Fri, 16 Jun 2023 02:21:16 GMT

Hi @Poorvi S

From this sample I'm assuming there will be no multiple Journal, WorkdayID or Combined_Purchase_Orders subelements for a single Report_Entry. So I would suggest you put the loop on Report_Entry.

This way the tXMLMap output should look something like this:

Journal-1|99340001|PO-100371

Journal-2|99340002|PO-100372

...