topic Re: Tmap Column order is changing automatically in Talend Studio

Tmap Column order is changing automatically

amtkmr1990 — Fri, 19 Jul 2019 08:28:02 GMT

Hi team,

In tmap i have columns as

Total_Space_GB, Free_SPACE_GB, SCHEMA_GB and other columns

I am changing the order of columns as

Other Columns first and then Total_Space_GB, Free_SPACE_GB, SCHEMA_GB at last

But after saving and closing and reopening i m seeing the order as

Total_Space_GB, Free_SPACE_GB, SCHEMA_GB and other columns

Re: Tmap Column order is changing automatically

Anonymous — Fri, 19 Jul 2019 10:48:55 GMT

This could be for a couple of reasons. First of all, do you click on "Apply" after you make the change in the tMap? If not, try that. Traditionally you could see a reversal in what you have done in the tMap if you did not apply it before clicking OK. This is not always the case, but it is auto-pilot for me to click "Apply" before "OK" when working in the tMap. Also, your tMap output I assume is linked to the schema of your tFileOutputDelimited. Have you tried changing that schema?

Re: Tmap Column order is changing automatically

amtkmr1990 — Fri, 19 Jul 2019 12:09:26 GMT

i tried both you your option but it did not work

Re: Tmap Column order is changing automatically

Anonymous — Fri, 19 Jul 2019 14:42:51 GMT

Can you show me the schema of the tFileOutputDelimited. Can you change it (input and output), save it and then open the schema again to see that it is still the same. This should change your tMap schema.

If you change the schema from the tMap you should see a "Do you want to propagate the schema" message. Click yes or OK to this.

Re: Tmap Column order is changing automatically

amtkmr1990 — Tue, 23 Jul 2019 05:40:10 GMT

attached the tFileOutputDelimited schema

Re: Tmap Column order is changing automatically

Anonymous — Tue, 23 Jul 2019 09:39:42 GMT

Did you follow the advice of my post above? You say that after saving the order changes. Have you tried running the job to see the changes have been implemented before saving?

Re: Tmap Column order is changing automatically

amtkmr1990 — Tue, 23 Jul 2019 11:54:21 GMT

Yes i tried your option. Tmap columns are in ordered now but the tdelimiteroutputed is not in order.

Re: Tmap Column order is changing automatically

Anonymous — Fri, 16 Aug 2019 02:30:08 GMT

Hi,

I am having the same issue in which I have a tfileoutputdelimited going to tmap, going to a tsalesforceout component (update) with log files afterward.Even though the tmap is set correctly, the output has field A's value going to field G, and vice versa. I am mirroring another job with the same set up that is working flawlessly. The mismapping ends up showing in the reject file after tsalesforceout.

Thank you,

Ichi

Re: Tmap Column order is changing automatically

Anonymous — Fri, 16 Aug 2019 12:12:52 GMT

@ichi2011 can you show the configuration of your job and the tMap?

Re: Tmap Column order is changing automatically

Anonymous — Fri, 22 Nov 2019 10:31:50 GMT

Hello, I don't know if you still have this issue, but you can try this as a temporary fix :when you update your schema IN TMAP and change the order, also change something else ( usually I uncheck the nullable field). This will save the changes and you just have to reopen, check back the nullable field, keep the order and save. However i don't know if this is related but when I restart talend, these changes are lost and the order go back to how it was.

EDIT: to help troubleshoot this issue, it seems that the unwanted re-ordering of the columns is done when editing schema through input and not tmap

Re: Tmap Column order is changing automatically

Ksudheer1596595370 — Wed, 05 Aug 2020 02:55:29 GMT

I am facing the same issue of column ordering is changing automatically, tried all the things mentioned above and tried deleting and taking new tmap component but same issue i am facing.