Forum Discussion
Transforming values from Records into columns and values (from Insightly API - Custom fields)
When you are expanding the List from image 1, what results are you getting ?
Try to expand List from image 1 and then expand records that comes as a results from expanding list.
Work with a List, Record, or Table structured column (Power Query) (microsoft.com)
Thanks for the support! If it wasn't for your help, I wouldn't have been able to find the solution.
After expanding the List and the Records into the table, I used the 'Pivot Column' functionality to do what I wanted!
Community ChampionWhen you are expanding the List from image 1, what results are you getting ?
Try to expand List from image 1 and then expand records that comes as a results from expanding list.
Work with a List, Record, or Table structured column (Power Query) (microsoft.com)
When I do that, they both expand, but they end up duplicating the rows and their values (the part in blue of the image below is the same value and should be a single row).
Is there a way to eliminate duplicates and merge the fields? Making the value of the column CUSTOMFIELDS.FIELD_NAME the column's name and the CUSTOMFIELD.FIELD_VALUE the value?