Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
vivek_m
Contributor
Contributor

remove first line from the file using header option in tAzureAdlsGen2Input

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.

0695b00000HApDEAA1.png

Thanks.

Labels (3)
3 Replies
Anonymous
Not applicable

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

 

 

 

 

Anonymous
Not applicable

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

vivek_m
Contributor
Contributor
Author

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