tAzureAdlsGen2Input - reading CSV file problem

[COW_WW]

Hello,

I have a csv file which looks like this:

The file doesn't have a header. When I'm using the tFileInputDelimited to read the file with the following settings it works as expected:

The result:

When I'm using the tAzureAdlsGen2Input with similar settings I'm only getting the first column:

Result:

Any idea what's wrong and how to get the rest of the columns?

[Anonymous]

Hello @COW_WW BA​ ,

As your test.csv file content is not strict csv content, there are 2 possible solutions for your case:

Solution 1:

a. fix the test.csv file content like:

b. setup the same schema fields name as the first line of the above csv file(need to remove the whitespace for the column name) in tAzureAdlsGen2Input component's schema.

c. and check the button "Use header" , Header =1

Solution 2:

a. Setup a Dynamic column for tAzureAdlsGen2Input 's schema like

[COW_WW]

Solution 1 is not an option as this is how we receive it from another department and we cannot fix the content.

Solution 2 I tried to define the column as Dynamic like in your screenshot but I'm still only getting the first column: