Forum Discussion
Dataflow creation - csv File is driving me insane, need help !
Hello !
To give some context, I have a bunch of csv files that I load manually once a month from AppleStore, and I need to digest these files into PBI to do some reporting of all the app installs that happened daily per country. ( I shortened my file for the purpose of posting here, so that the issue I'm having is clear )
These files have the following structure :
The highlighted row 5 is problematic, of course a solution could be to manually delete the first 4 rows, remove the extra " ".. But, what I'm looking for here, is a way to do and automate this kind of transformation in my dataflow.
Another Screenshot from PBI service when trying to digest this file :
So that's it, I'm having a big blockage at this step.. Would really appreciate some insight from more experienced people here.
Any Help, or tip is highly welcomed.
1 Reply
Check your CSV files with a hex editor to see if there is a character between the double quotes "" that you could use for splitting.
Is it right to assume that only the rightmost country in that line is important?
