Im trying to convert a column with JSON-data to new columns. This is my input:
I need my output like this:
I'm trying to convert my 'assessments' column to JSON in the Power Query Editor, but not getting the right outcome:
let
Source = objects,
#"Parsed JSON" = Table.TransformColumns(Source,{{"assessments", Json.Document}}),
#"Expanded assessments" = Table.ExpandRecordColumn(#"Parsed JSON", "assessments", {"36", "43"}, {"product_id", "value"})
in
#"Expanded assessments"
Thanks in advance!
Solved! Go to Solution.
Hi @lionzandvliet ,
If you have the information has you present in the first image you just need to make some addtional steps:
Check PBIX file attach, it's not based on JSON but you only need the steps after "opening" the JSON that is what I show here.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @lionzandvliet ,
If you have the information has you present in the first image you just need to make some addtional steps:
Check PBIX file attach, it's not based on JSON but you only need the steps after "opening" the JSON that is what I show here.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsJoin us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
119 | |
76 | |
66 | |
51 | |
49 |
User | Count |
---|---|
183 | |
101 | |
80 | |
79 | |
77 |