Read CSV changes the name of columns with underscores between letters

[etsimard]

Hello Everybody

I am importing a csv file using read csv node and when I run the node, all my column names in the node monitor only shows the first letter of the actual column name.

When I add a node for example Column rename, I see the names normally

When I do an unpivot node, I see the real column name with an underscore (_) between each letter

When I do an excel writer, the column has all characters separated by a ? instead of the underscore,

Has this happened to anyone before? please help

[etsimard]

here are some screenshots to better demonstrate

[hmfa]

Hi @etsimard

It looks like there’s a problem with the column headers.
Can you inport without the column headers and promote first row to header?

Copy or Move first row to column header – uie63112

Br

[etsimard]

Hello

It seems that the issue arrives before that step as this is what it looks like when I remove headers:

the underscores are also there

[etsimard]

It is now fixed,

At first I had to click on support short data rows as there were some problematic rows. Now I unclicked the box and the column names are OK and the problematic rows from short data are magically not an issue anymore.

Thanks for your help