Forum Discussion
Record and List to Table
Make sure you select your value column for the values in your pivot and choose "Don't Aggregate".
Or here is an expression you can put in a custom column. Replace Custom with your column that has your list of records (before you expand, pivot, etc.).
let inputlist = [Custom], fields = List.Transform(inputlist, each _[name]), values = List.Transform(inputlist, each _[value]), result = Record.FromList(values, fields) in resultPat
Hi ppm1,
this creates values of 1 and 0, depending if there is data (1) and when there is no data (0). But not the actual data itself.
Can you write me the code of your other solution (List.Transform), because I have tried some things but it didn't work out. I was getting all errors.
Make sure you select your value column for the values in your pivot and choose "Don't Aggregate".
Or here is an expression you can put in a custom column. Replace Custom with your column that has your list of records (before you expand, pivot, etc.).
let
inputlist = [Custom],
fields = List.Transform(inputlist, each _[name]),
values = List.Transform(inputlist, each _[value]),
result = Record.FromList(values, fields)
in
result
Pat