Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power Query - csv file column values is mixed with values from other column

Hi, I am having a trouble when I import a csv file to Power Query. Originally and on my csv source file, I only have these data on my Column A (on green box).  But when I imported my csv fil...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks Anonymous for your advice.
     
    Yes I am using "" as my delimeter, and when I changed to whitespace or tab or something, it gives the same error. 

    However,  I tried to changed the Line Breaks from "Apply all line breaks" to "Ignore quoted line breaks" and surprisingly, it works 🙂 No mixed data from other columns already. And I am still using "" as my delimeter. 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Are you using """ (") as your delimiter? You may be better off splitting them on whitespace or tabs or something.

 

--Nate 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks Anonymous for your advice.
     
    Yes I am using "" as my delimeter, and when I changed to whitespace or tab or something, it gives the same error. 

    However,  I tried to changed the Line Breaks from "Apply all line breaks" to "Ignore quoted line breaks" and surprisingly, it works 🙂 No mixed data from other columns already. And I am still using "" as my delimeter.