0

I have a given dataframe, that has list in a list_column and unique id for each row in id column

id list_column
323 [13,45,123, 79]
123 [11,25,45]

From that dataframe, I want to create this dataframe

id opened_list_column
323 13
323 45
323 123
323 79
123 11
123 25
123 45

I was thinking about adviced to use UNIONS in that case, but I really do not know how to approach this case

  • 1
    you join the `JSON_TABLE` table constructor for this (requires mariadb 10.6 or mysql 8). https://dbfiddle.uk/WH57ypot – ysth Nov 22 '22 at 01:23

0 Answers0