Help read simple csv

[Hamder83]

Hi 

How do I read this csv if I wanna keep the header? 

I have tried \0 delimiter, and then text to columns,.

And I have tried all the settings I can find in the input.. but I cannot get it to load it correctly?

[danilang · Accepted solution]

hi @Hamder83 

The issue is that the lines are longer than the default 256 char input length.  Change this to a much larger number, i.e. 10000 and it comes in fine.  Uncheck First Row Contains Field Names as well. 

Then use a Text to Columns and Dynamic Rename 

Dan 

[Qiu]

@Hamder83 
I modified some data and now the whole data can be pulled in.

[Hamder83]

Thanks for the reply both of you 🙂 

Your solutions worked like a charm! 🙂