topic Re: tAzureAdlsGen2Input - reading CSV file problem in Talend Studio

tAzureAdlsGen2Input - reading CSV file problem

COW_WW — Fri, 15 Nov 2024 21:47:39 GMT

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?

Re: tAzureAdlsGen2Input - reading CSV file problem

Anonymous — Thu, 18 May 2023 02:48:06 GMT

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

Re: tAzureAdlsGen2Input - reading CSV file problem

COW_WW — Thu, 18 May 2023 14:02:14 GMT

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: