Help in script

[#1]

hi,

i have a table such as given below

Column 1	Column 2
1	x,y,z
2	a,b,c

and i want to transform it into

Column 1	Column 2
1	x
1	y
1	z
2	a
2	b
2	c

thanks in advance

[Gysbert_Wassenaar · Accepted solution]

LOAD

     [Column 1],

     SubField([Column 2],',') as [Column 2]

FROM   

     ...source...

     ;

[yadhunandhanan]

Hi Nishit,

Use below attachment. Hope its help.

Thanks gwassenaar

[Anonymous]

Hi

Please find attached

Hope it helps !