Forum Discussion
Anonymous
3 years agoNot applicable
Issue with Split Column with Delimiter from Sharepoint CSV
Hi I have a csv file with 14113 columns to load to Power Query. It goes something like this "id","address","score" "129023","new york, USA","30" If I download the csv file to my local and g...
- Anonymous3 years ago
Yes, to this binary type column you have to apply the formula i told you in the second message.
Create a custom column and write that:
Csv.Document([Content],[Delimiter=",", Encoding=1252])
This would be the code:
let Source = SharePoint.Files("https://jardon.sharepoint.com/sites/Supply/", [ApiVersion = 15]), #"Filtered Rows" = Table.SelectRows(Source, each Text.Contains([Folder Path], "The Raw Data")), #"Custom column added" = Table.AddColumn(#"Filtered Rows", "Custom Column", each Csv.Document([Content],[Delimiter=",", Encoding=1252])) in #"Custom column added"
Anonymous
3 years agoNot applicable
i got it now! thank you so much π
Anonymous
3 years agoNot applicable
YouΒ΄re welcomeπ