The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have imported a JSON file and I have performed some actions until I get a column with nested lists inside, whici I need to get the records. Inside the first list, can also be 1 or more lists, and so on and so on.
The following table is a represention of the problem.
How can I expand all these lists (and the records inside them)? It can be a solution that results into multiple lines, I can then group by ID. I saw some examples from this forum and other places but I struggle to understand some of the code 🙂
ID | Column |
1 | {List1},{List2} |
2 | {List1},{List2},{List3},{List4} |
3 | {List1} |