separate table field

[omid5ive]

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?

[Anil_Babu_Samineni · Accepted solution]

Where you are expecting? If script may be this?

LOAD ID, SubField(A,',') as A;

LOAD ID,

      A

FROM

<Source>