Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

CSV import is splitting JSON data into their own columns

Hey everyone, I'm running into an issue...I have a .csv file that is a table dump from a provider. Hence, I have no real control over the formatting of the data...I have to play the hand I'm dealt. S...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    Glad to hear that you have resolved your problem. Thank you for sharing this wonderful solution, would you please kindly mark your sharing solution as an answer so that it can benefit more users?


    Best regards,

     

alena2k's avatar
alena2k
Icon for Resolver IV rankResolver IV
6 years ago

I see. Can you open it as a text file instead of .csv?

 

let
Source = Table.FromColumns({Lines.FromBinary(File.Contents("C:\sample.csv"), null, null, 1252)}),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}})
in
#"Changed Type"

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I can give that a whirl but I'm confused, is this truely an issue that is seldom seen? I would suspect that anyone who dumps a DB table into a .csv could run into this. Hmmm....

  • alena2k's avatar
    alena2k
    Icon for Resolver IV rankResolver IV
    6 years ago

    import of .csv accepts different delimeters, but comma is a default. You can change delimeter to be somethign what's not in the file or nothing (as text). I would not expect .csv export to work in any other way.