topic remove first line from the file using header option in tAzureAdlsGen2Input in Talend Studio

remove first line from the file using header option in tAzureAdlsGen2Input

vivek_m — Fri, 15 Nov 2024 23:53:15 GMT

Hi ,

I have a scenario to read adls gen 2 file and load it into azure database.

I tried with "header" option in the input but it is giving values for all the columns. but if i uncheck it , it gives the records properly with columns values as 1st line.

help me here with some example scenario for header usage.

Thanks.

Re: remove first line from the file using header option in tAzureAdlsGen2Input

Anonymous — Fri, 06 Aug 2021 08:43:06 GMT

Hello,

We are supposing that you have already checked the component reference about: TalendHelpCenter: tAzureAdlsGen2Input

Does its header match the schema?

So far, this component refuses to read text files unless the file contains a header matching the schema mentioned in the component for V 7.3.1.

In studio tAzureAdlsGen2Input there's a "header" checkbox, and when it's enabled - column names is taken from first line (and therefore first line is not considered as "data")

When it's disabled, default column names ("field0", "field1", ...) are used.

Best regards

Sabrina

Re: remove first line from the file using header option in tAzureAdlsGen2Input

Anonymous — Fri, 06 Aug 2021 08:44:51 GMT

Hello,

Here exists a new featureTDI-44626: dynamic column for TCK and it is fixed in 7.3.2, 7.3.1-R2020-09, 8.0.1

Best regards

Sabrina

Re: remove first line from the file using header option in tAzureAdlsGen2Input

vivek_m — Fri, 06 Aug 2021 10:46:47 GMT

Hi Sabrina,

Thanks for the details. In my case , number of columns were not matched. Now I changed and it is working fine.

Best Regards,

Vivek M