topic Re: THMAP output ordering in Talend Studio

THMAP output ordering

Anonymous — Sat, 16 Nov 2024 08:56:29 GMT

We have a requirement to create a complex xml for which we are using THMAP.

In the job we are converting the data to a CSV then from CSV we are creating the xml.

We are having a problem with the sequence.

expected output - All elements for set 1 in CSV should come first followed by all elements of Set 2

But THMAP is generating in below fashion

<FEED>
<entry 0>

<entry 0>
<entry 2>

<entry 2>
<entry 3>

<entry 3>
<entry 4>

<entry 4>
<entry 5>

<entry 5>
<entry 6>

<entry 6>
<\FEED>

Any suggestion to address the sequencing would be helpful.

Re: THMAP output ordering

Anonymous — Tue, 19 Dec 2017 11:04:20 GMT

Hi,

Could you upload your map and a test input file ?

Eric

Re: THMAP output ordering

Anonymous — Tue, 19 Dec 2017 13:11:38 GMT

Attached is the mapper along with the test data

Re: THMAP output ordering

Anonymous — Tue, 19 Dec 2017 13:12:43 GMT

Please refer to the talend.zip folder

Re: THMAP output ordering

Anonymous — Tue, 19 Dec 2017 16:30:05 GMT

Hi,

According to which input field to you want to sort your output ? id2 ? Index line number ? Other ?

Eric

Re: THMAP output ordering

Anonymous — Tue, 19 Dec 2017 18:12:13 GMT

Preference is to have the entries appear in the same sequence as they appear in csv.
ID2 would be the 2nd choice.

Regards
Satyakam

Re: THMAP output ordering

Anonymous — Wed, 20 Dec 2017 08:03:25 GMT

Hi,

Here is a suggestion:

1- Add an index in your input file:

2-Map it to your XML output (For every entry records)

3-Create a second map from XML to XML format that will sort your "Entry" records (Don't map the index field if you don't want it in the output):

4-Then call this second map from your first map. To do that, right click on your map and choose 'properties' then enter your second map name in "next map" field

Does it meet your requirements ?

Regards.

Eric

Re: THMAP output ordering

Anonymous — Fri, 12 Jan 2018 05:28:06 GMT

Hi Eric - sorry was out sick.

Will try your suggested solution and let you know the out come. Thanks for your help

Re: THMAP output ordering

Anonymous — Tue, 16 Jan 2018 13:39:57 GMT

Thanks Eric. It worked for me.

Final Resolution : MAP1(having CSV to XML) --> MAP2 (XML to XML) Sort Applied on MAP2 --> File written to drive

Re: THMAP output ordering

Anonymous — Fri, 18 Oct 2019 23:47:41 GMT

Where is the zip file?