Data Load Problem

[#1]

Hi All,

I have some data layed out like this

Territory              Towns

1                              A,B,C,F

2                              G,Y,W,E

What I want to do it transform it to this…

Territory              Town

1                              A

1                              B

1                              C

1                              F

2                              G

2                              Y

2                              W

2                              E

Any ideas how I can do this?

[rwunderlich · Accepted solution]

Load Territory, subfield(Towns, ',') as Town

Rob

[jagan]

Hi,

Hope the attached file helps you.

Regards,

Jagan.