output column order

Five Stars

output column order

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?

Nine Stars

Re: output column order

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

Sounds strange.
Can you post screenshots plz?
Regards
DGM
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: output column order

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.PNGlink

 

output1.PNGoutput

 

Community Manager

Re: output column order

@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

----------------------------------------------------------
Talend | Data Agility for Modern Business
Five Stars

Re: output column order

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

Re: output column order

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads