Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
69
Views
Topic starter
Hello,
I have a column located in the middle of my data that include commas within the cell. When I comma delimit the .csv file it will also separate by commas within a cell and mess up the data formatting. When you manually use the data delimiter it offers on the wizard a "Do Not Import Column skip" action. How can I do the same within Power Query when I upload the .csv file?
Thanks
Posted : 14/04/2018 4:11 pm
Hi Vanessa,
Power Query doesn't have this option, but you can join the columns back together using Merge Columns and set the delimiter to a comma.
Mynda
Posted : 15/04/2018 6:40 am
Topic starter
Thank you Mynda
Posted : 18/04/2018 2:43 pm
