Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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} |