Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Data Load Problem

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

Rob

2 Replies

Data Load Problem

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

Rob

MVP
MVP

Re: Data Load Problem

Hi,

Hope the attached file helps you.

Regards,

Jagan.

Community Browser