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?
Solved! Go to 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
@Hamder83
I modified some data and now the whole data can be pulled in.
Thanks for the reply both of you 🙂
Your solutions worked like a charm! 🙂