Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i have a table like below:
id | A |
---|---|
100 | 1,2,3,4 |
200 | 2,5,6 |
i want to convert it to a table like below:
id | A |
---|---|
100 | 1 |
100 | 2 |
100 | 3 |
100 | 4 |
200 | 2 |
200 | 5 |
200 | 6 |
what can i do?
Where you are expecting? If script may be this?
LOAD ID, SubField(A,',') as A;
LOAD ID,
A
FROM
<Source>
Where you are expecting? If script may be this?
LOAD ID, SubField(A,',') as A;
LOAD ID,
A
FROM
<Source>