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

NNayal1600240775 — Fri, 15 Nov 2024 23:41:37 GMT

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?

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

Anonymous — Tue, 12 Oct 2021 07:06:52 GMT

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

topic Re: Merge the header data in one file with data in other file without defining schema in Talend Studio

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

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