Data Load Problem

Tue, 13 Mar 2012 18:19:23 GMT

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 — Tue, 13 Mar 2012 20:17:23 GMT

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

Rob

Re: Data Load Problem

jagan — Wed, 14 Mar 2012 06:44:55 GMT

Hi,

Hope the attached file helps you.

Regards,

Jagan.