Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
LOAD
[Column 1],
SubField([Column 2],',') as [Column 2]
FROM
...source...
;
LOAD
[Column 1],
SubField([Column 2],',') as [Column 2]
FROM
...source...
;
Hi
Please find attached
Hope it helps !