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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
NNayal1600240775
Contributor III
Contributor III

Merge the header data in one file with data in other file without defining schema

My file were having column name descrepencies...

so i used tfileinputfullrow - and read the header - corrected the column name and stored the header in one file.

Now iam reading this header file and the rest of the data from the input file using dynamic schema (Since I want my job to be generic - so I do not want to define the schema).

Now when Iam merging these 2 files using tunite - the file with correct header -iam not able to read it since dynamic schema skips the header.

How can I correct this in talend?

tfileinputdelimited_2 is reading 0 rows because of dynamic schema.. what are the other way i can merge my header data with rest of data?

0695b00000JMrAJAA1.png

Labels (4)
1 Reply
Anonymous
Not applicable

Hi

Using a tFileInputFullRow to read only the first line (header row) ​and write it to a new file, and then merge the two files using tUnite and append the data to the file created just now.

 

Regards

Shong