Forum Discussion

SysLostInBI's avatar
SysLostInBI
Frequent Visitor
6 years ago
Solved

Working with JSON and multiple List

I'm sure this is a very basic question, so I feel bad bothering you with this. But I'm stuck with this.   I have imported a JSON file: {     "result": [         {             "metricId": "xx"...
Need Help
Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi SysLostInBI 

 

Try this steps

let
    Source = Json.Document(File.Contents("C:\Users\mrepczynski\OneDrive - Network Homes\Desktop\test.json")),
    result = Source[result],
    result1 = result{0},
    data = result1[data],
    Custom1 = Table.FromRecords( data ),
    #"Transposed Table" = Table.Transpose(Custom1),
    #"Added Custom" = Table.AddColumn(#"Transposed Table", "Custom", each List.Combine( { [Column1], [Column2] } )),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Custom"}),
    Custom = Table.FromRows( List.Zip( #"Removed Other Columns"[Custom] ) )
in
    Custom

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn