I have a dataframe with one row like below –
| col1 | col2 | col3 |
|---|---|---|
| [a,b,c] | [i,ii,iii] | [1,2,3] |
Now I need to transfer it into –
| col1 | col2 | col3 |
|---|---|---|
| a | i | 1 |
| b | ii | 2 |
| c | iii | 3 |
I have tried to use explode. But select clause allowed only one explode function which is very logical.
can anyone help me with this?
Thank you inn advance.