Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Load Problem

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?

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Rob

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Rob

jagan
Luminary Alumni
Luminary Alumni

Hi,

Hope the attached file helps you.

Regards,

Jagan.