Forum Discussion

some1else's avatar
some1else
Helper II
3 years ago

Expanding ALL nested lists in column

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 🙂

IDColumn
1{List1},{List2}
2{List1},{List2},{List3},{List4}
3{List1}
No RepliesBe the first to reply