Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try using subfield() like:
Load USER, SubField(ROL, ',') as ROL From <>;
Try using subfield() like:
Load USER, SubField(ROL, ',') as ROL From <>;