Forum Discussion

orghn's avatar
orghn
Helper I
4 years ago

Error Import many JSON from folder

Hi, I have many JSONs in a folder an I need to combine and transform with power query.   The issue is that the JSONs have different date ranges, so when I try to Export all the JSONs from a folder,...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

Combining the files is the easy part

 

let
    Source = Folder.Files("C:\Users\xxx\Downloads"),
    #"Filtered Rows" = Table.SelectRows(Source, each Text.StartsWith([Name], "out_n")),
    #"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Content", "Name"}),
    #"Added Custom" = Table.AddColumn(#"Removed Other Columns", "Custom", each Record.ToTable(Json.Document([Content],1252))),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Name", "Value"}, {"Name.1", "Value"})
in
    #"Expanded Custom"

 

But then you have to decide how to parse the JSON - that is something you need to do before you can continue.