Forum Discussion
How to explode nested list items?
Of the four rows one of them is a List. Drilling down this list gives 15 rows of "Record". Drill down this "Record" gives another set of rows which has a "Record" and drilling down this to fet the final set of data. All of this drilling down is for one item only. I have to manually drill down all the items which is not possible. The icon of "two opposite arrows" to show all the data does not appear here.
I want to select some columns from the each drilled down level and make one table. this table should have the following columns,
item_number - showing all the item numbers from all the nested levels
Quantiy - from level 2
major rev - from level 3
Attached is the screenshot
There is no magic to it. You are trying to fit a round hole (JSON hierarchy) into a square peg (Power Query table). The only way is a manual way, and you need to make decisions and compromises along the way to decide what to flatten and what to discard.
2 Replies
There is no magic to it. You are trying to fit a round hole (JSON hierarchy) into a square peg (Power Query table). The only way is a manual way, and you need to make decisions and compromises along the way to decide what to flatten and what to discard.