Compare incoming csv fike's schema and add the missing columns with respect to reference schema

[Anonymous]

Hi Folks,

I have a requirement in which a reference schema will be there, like : Column A,B,C,D,E,F.

in Day1 : the incoming csv file contains Column A,B,D,F

So, I have to detect the missing columns(i.e : Column C,E) and ingest these 2 columns in the incoming csv file and make a new CSV file with columns A,B,C,D,E,F.

Having null values for Column C,E.

Please suggest me a way to achieve this in Talend.

Thanks in advance

Regards

Subhadeep

[fdenis]

hi, what is your mission?
adding columns or inserting data into a db?
adding columns:
1 read first line as raw then normalise then compare to template.
2 fill each line with neaded null value.

inserting data into a db:
insert each line into a temp table then use store proc to read header and generate corresponding insert.

[Anonymous]

Hi,

My input is :

Col A	Col C	Col D	Col F
1	1	1	1
1	1	1	1
1	1	1	1

My Output should be :

Col A	Col B	Col C	Col D	Col E	Col F
1		1	1		1
1		1	1		1
1		1	1		1

Thanks in advance

[fdenis]

are your input file in a fix format?