Talend Cloud 7.1 - Issue when using Dynamic Schema with CSV file

[Safus]

Hello Community, 

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

[Anonymous]

Hello,

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.

Best regards

Sabrina

[Anonymous]

Hi,

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.

Kind regards,

Michael

[David_Beaty]

Hi,

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.