Tmap Column order is changing automatically

Six Stars

Tmap Column order is changing automatically

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 

 

Community Manager

Re: Tmap Column order is changing automatically

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?

Six Stars

Re: Tmap Column order is changing automatically

i tried both you your option but it did not work 

Community Manager

Re: Tmap Column order is changing automatically

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.

Six Stars

Re: Tmap Column order is changing automatically

attached the tFileOutputDelimited schema 

Community Manager

Re: Tmap Column order is changing automatically

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?

Six Stars

Re: Tmap Column order is changing automatically

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

One Star

Re: Tmap Column order is changing automatically

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

 

 

Community Manager

Re: Tmap Column order is changing automatically

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

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch