Support Questions
Find answers, ask questions, and share your expertise

Explode a column in a table

Explode a column in a table

I have a table and i want to explode a column in the table

i want to explode additonal ip column

Input-

ip, additional ip, server

a,  a,b             , server 1

c,  c,d,e           , server 2

 

Output-

ip, additional ip, server

a,  a,b             , server 1

b,  a,b             , server 1

c,  c,d,e           , server 2

d,  c,d,e           , server 2

e,  c,d,e           , server 2

 

@MattWho