I'm reading a csv file Dynamically but it seems that this data structure is deleting the first row (The mot important one in my case)
You can see that my file contains 109 row but the tFileInput seems to read 108.
Same file, with same configuration and changing Dynamic to String is working perfectly.
I need to read the file dynamically because columns number is variable and is I need to pivot my file according to the first missing line (Header of my file).
Any Idea ? Thank you
Are you able to upload your screenshots by clicking the "photos"? Let us know if there is any problem when you upload your screenshots on community.
As far as I know you always need to have a header row when using Dynamic schema's, Talend determines the dynamic schema (and also column names I guess) using this header.
Also, don't forget that when reading data in from a dynamic schema, it wont know what the column types are, only how many there are - they will all be treated as strings - so nulls for numbers and dates will become things like 0 and 1900-01-01.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables