Forum Discussion
Duplicate rows when expanding JSON list
Hi, I'm having some problems to expand a list from a JSON document in Power Query. Look this figure: The columns dimensions and dimensionsMap have just one value. The column timestamps ...
You can add a custom column with a formula like this to combine those lists into a table. You can then expand that table.
= Table.FromColumns({[dimensions], [dimensionsGroup]})
Pat
You can add a custom column with a formula like this to combine those lists into a table. You can then expand that table.
= Table.FromColumns({[dimensions], [dimensionsGroup]})
Pat