Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous,

In fact, this result works as expected as expand feature designs. (Raw table records will be multiple if you expand one field record)
In my opinion, I'd like to suggest you add an index field to your table and do unpivot column on the field which you wanted to expand. Then your field will be converted to 'attribute' and 'value' and you can expand them at the same time without duplicate these field values. 

After these steps, you will get the unpivoted and expand fields value that mapping with index field values. You can do some mapping and pivot operations to transfer them to raw table structures.
Regards,

Xiaoxin Sheng