topic Re: output column order in Talend Studio

output column order

Anonymous — Thu, 18 Jul 2019 12:53:14 GMT

I have a strange behavior in TOS. My flow is vey simple:

- Few input delimited files

- One tMap which joins them

- One output delimited file

In tMap is defined correct column order:

- col1

- col2

- colX

In link between tMap and output file is correct column order:

- col1

- col2

- colX

However when I look to output file column order I get:

- colX

- col1

- col2

I have tried already:

- deleting output file and creating it one more time

- change column order in the output file by editing Built-In schema (using those positional arrows)

- remove colX from output schema and manully selecting it via -> arrow while editin Built-In schema

- export built-in schema into XML, change order of columns and import back

- remove all columns while editing Built-In schema. After I pressed "Sync columns" button, I still get wrong column order; colX is still at the beggining.

It seems like nothing helps. How can I get colX at the end of the header for output file?

Re: output column order

Anonymous — Thu, 18 Jul 2019 16:36:16 GMT

I don't think it's possible to have that.

Sounds strange.
Can you post screenshots plz?

Re: output column order

Anonymous — Thu, 18 Jul 2019 17:42:21 GMT

What do you mean by "I don't think it's possible to have that."? You mean that you can't have proper column order in the built-in schema? How do you then solve the situation when you are exchanging data with somebody (he is reading your output) and suddenly you need to add new field to this output. It should not change the existing file structure in my opinion in a way that old columns will be on different positions.

Screenshots:

link

output

Re: output column order

Anonymous — Fri, 19 Jul 2019 11:28:50 GMT

@pepco, I can confirm it is a bug on version 7.2.1, I have open a jira issue.

https://jira.talendforge.org/browse/TDI-42547

If you have the same issue, please go to the jira issue, add your comments and monitor the issue.

Regards

Shong

Re: output column order

Anonymous — Fri, 19 Jul 2019 11:43:27 GMT

I can't see the issue on the jira dashboard with my community acccount. Maybe it has wrong permissions?

Re: output column order

Anonymous — Mon, 19 Aug 2019 08:10:12 GMT

Hello,

Here exists a related jira issue:https://jira.talendforge.org/browse/TUP-23809

Best regards

Sabrina

Re: output column order

Anonymous — Mon, 20 Jan 2020 21:56:36 GMT

I was having the same issue. I attempted the same steps as you. I finally saved the file. Closed it, then reopened. The columns were in the right order. Not sure if this helps in your situation.

Re: output column order

jebiya — Mon, 22 Nov 2021 18:32:19 GMT

i am still experiencing a similar issue in 7.2.1 but the link to this jira issue does not work for me. is there another link or a different jira issue?

Re: output column order

Anonymous — Tue, 23 Nov 2021 03:55:15 GMT

Hello,

Regarding of this jira issue, it was fixed in 7.3.1, 7.2.2.

Have you already tried to use V 7.3.1 to see if it reproduces in 7.3.1?

Best regards

Sabrina