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 fi...
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.
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.
Well, could have done without the sarcasm but still thanks for the reply. It helped.