topic Re: Talend Cloud 7.1 - Issue when using Dynamic Schema with CSV file in Talend Studio

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

Safus — Sat, 16 Nov 2024 05:38:00 GMT

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

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

Anonymous — Mon, 17 Jun 2019 08:34:03 GMT

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

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

Anonymous — Mon, 17 Jun 2019 13:05:24 GMT

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

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

David_Beaty — Tue, 25 Jun 2019 20:38:04 GMT

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.