Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    3 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"