Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to handle inconsistent header for constant target schema in Talend?

Hi Team,

Please solve the following,

My Target schema having columns like,

 

Ename (varchar),
Enumber (Integer),
Salary  (Float)

Scenario 1:
The input file header is,

Ename,Enumber,Salary

Scenario 2:
The input file header is,

Enumber,Ename,Salary

Scenario 3:
The input file header is,

Salary,Enumber,Ename

If we observe in the above three scenarios,the columns are same but the order of the columns is different.

How can we load the data of input file (i.e The order of the columns in header is inconsistent) to target schema?

 

Thanks in Advance.

 

 

Labels (2)
1 Reply
akumar2301
Specialist II
Specialist II

Open source or Subscription version ?

 

On Subscription version 

https://help.talend.com/reader/XYG1yAFeBFz4I4dovmWbsQ/Sqn2UjC4NG9K7BRgJys7zg