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 file in Power Query,  a lot of data from Column B is mixed up on Column A (around 850 records actually).

Need help. I am having a lot of errors when I load it to my PBI and having wrong output figures. 
Thanks a bunch in advance. 

 

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. 

2 Replies

  • 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.