Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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} |
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
24 | |
12 | |
11 | |
11 | |
8 |
User | Count |
---|---|
43 | |
25 | |
15 | |
14 | |
12 |