Split one delimited field into x

[Pedro_Rodriguez]

Hi all,

I have something like this:

USER	ROL
a	1,2,5
b	2,4
c	1
d	3,4,5

And I want to end up with something like this:

USER	ROL
a	1
a	2
a	5
b	2
b	4
c	1
d	3
d	4
d	5

That is splitting the field Rol into x rows.

Thanks a lot in advance!

[tresesco · Accepted solution]

Try using subfield() like:

Load
        USER,
        SubField(ROL, ',') as ROL
From <>;