topic Re: tMap changes the column order in Talend Studio

tMap changes the column order

peterko — Sat, 16 Nov 2024 04:15:58 GMT

Hi,

tMap changes the column order for the output automatically.

I set the column order, clicked apply button, OK and when I close the job and reopen the job, then the order of output schema is different (newly added columns are on the top instead of my setup).

It's simple job:

CSVSource (schema is OK) --> tMap (output schema is changing automatically all the time) --> tMap (output schema is changing automatically all the time) --> DBInsert (schema is OK)

Re: tMap changes the column order

Anonymous — Fri, 25 Oct 2019 17:45:01 GMT

The input schema of your first tMap should match your CSV Source schema. Is this the case? The output schema can be affected by the schema of the component you are linking to. These schemas should match. Does your output schema from your 1st tMap match the input schema of your 2nd tMap?

Re: tMap changes the column order

peterko — Fri, 25 Oct 2019 17:56:12 GMT

yes, the Input schema matches the CSV schema. But the output schema is changing all the time.

I've tried to rename some of the columns, remove the connection between the components (without deleting the output schema in tMap), but nothing works.

The only solution I found is to create a new tMap component and set the columns again, which is a really bad solution, because if the schema contains 30 columns and every column has JAVA transformation code so it takes a lot of time with the possibility to make a mistakes during copying the code... So it's a really weird bug. My colleague has the same issue on another project and on another computer (but the same TOS-DI version). So it seems as an application bug.

Re: tMap changes the column order

Anonymous — Fri, 25 Oct 2019 21:32:26 GMT

Is this a job that you could export and send to me? I'd be interested to take a look and see what I can find. Also, what version are you using?

Re: tMap changes the column order

Anonymous — Tue, 29 Oct 2019 09:28:48 GMT

Hello,

Here exists a jira issue:https://jira.talendforge.org/browse/TUP-23809 and it is fixed in 7.3.1, 7.2.2.

Let us know if it is what you are looking for.

Best regards

Sabrina

Re: tMap changes the column order

MaheswarReddy — Tue, 29 Oct 2019 09:34:38 GMT

Hi peterko,

Even i was facing the same issue . and this was a bug

This was a bug in Talend and as @xdshi mentioned, It is fixed in the latest versions of Talend.

Thanks,

Mahesh.

Re: tMap changes the column order

peterko — Tue, 29 Oct 2019 13:52:56 GMT

Thanks.

I'm using v7.2.1. so that's a case. I did exactly as it is described in the fix, but it's a problem in case you have 30 columns with custom expressions...

Unfortunately I haven't find the version 7.2.2 for download. Any ETA when v7.3.1 should be released as the stable version?

Re: tMap changes the column order

Anonymous — Wed, 30 Oct 2019 02:59:50 GMT

Hello @peterko

Here are the newly added features for 7.3.1M1
https://jira.talendforge.org/issues/?filter=30425
and bugfixes:
https://jira.talendforge.org/issues/?filter=30430

The 7.3 GA is probably available in Feb, 2020.

Best regards

Sabrina

Re: tMap changes the column order

FrancoisSmfy — Tue, 21 Jan 2020 08:23:27 GMT

Hello,

You said that the issue is fixed in the 7.2.2 version, but this version is nowhere to be found.

We try to get the code modification from Git, but it require a compilation, not just a file modification.

The time between 2 two versions of Talend (7.2 > 7.3) are quite long, how the TOS users can patch their installation ?

Re: tMap changes the column order

Anonymous — Tue, 21 Jan 2020 09:29:48 GMT

@sm, unfortunately, the TOS user can not patch their installation, you have to wait for the new release. For testing, you can download the milestone version 7.3.1M5 and validate if it fix the bug.

Re: tMap changes the column order

FrancoisSmfy — Tue, 21 Jan 2020 10:10:49 GMT

Ok for the absence of patches for the TOS version. But what about the 7.2.2 version mentionned in the Jira issue? Does it exists somewhere?

Before the 6.4, Talend released revisions of the TOS minors versions, with bug fixes : 6.2.2, 5.6.3

Re: tMap changes the column order

Anonymous — Wed, 22 Jan 2020 03:11:48 GMT

v7.2.2 is not released yet. Please wait for 7.3 GA version which will be available in Feb, 2020.

Re: tMap changes the column order

Anonymous — Tue, 04 Feb 2020 12:15:52 GMT

Hello.
Im using the 7.2 version and this issue has not been fixed

Re: tMap changes the column order

Anonymous — Tue, 04 Feb 2020 14:32:11 GMT

It is not fixed in 7.2. Those using the Enterprise Edition will have access to patches, Open Source users do not and will have to wait until 7.3

Re: tMap changes the column order

varun1949 — Wed, 05 Feb 2020 10:45:57 GMT

Team- do we have any update on this ?

It's a big bug in 7.2.1

1. Any update/Patch for 7.2.2 ? I can see in the comments it will be fixed in v7.2.2, I am using enterprise version already.
2. We are in Feb already when is v7.3 coming ?

3. I can see JIRA are already resolved ? How this can be possible ?

Re: tMap changes the column order

Anonymous — Wed, 05 Feb 2020 11:52:18 GMT

Hi @varun1949, if you are using the Enterprise version, you will have a support contract. You need to raise a support call and they will deal with this. I believe there is a patch, but you have to ask them for it.

Re: tMap changes the column order

varun1949 — Wed, 05 Feb 2020 12:52:01 GMT

Okay sure, got it !! I will do it right away !! , Thanks so much for your quick reply.

Re: tMap changes the column order

rakeshpdgupta23 — Sun, 09 Feb 2020 20:03:02 GMT

Yes,its a Bug in Talend. Even I was giving demo for Talend 7.2. suddenly it changes the column order.
For time being we can use metadata repository to deal with this issue till the time it got fixed from talend.

Re: tMap changes the column order

varun1949 — Tue, 11 Feb 2020 10:40:39 GMT

The patch is given by Talend team it'self , please ask them and it worked perfectly after that !!