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

Transpose interval FROM - TO

Hi,
I am quite new with QlikView and now I'm trying to solve the following problem (even don't know if this is possible or not). Let me try to explain.
As example, I have two tables with the following structure:
The fist table contains a list of profiles and an interval for each profile. (if the field To is empty the profile has just the value in field from)
ProfileFromTo
A001X10
A002X11X18
A002L12
A003M5X15
In the second table I have an ordered list of all possible values of fields FROM and TO (domain for that field):
Header 1
L12
L15
M1
M3
M5
X10
X11
X15
X17
X18
I would like to obtain a table with stored a row for each profile and any possible value, for our example:
Header 1Header 2
A001X10
A002X11
A002X15
A002X17
A002X18
A002L12
A003M5
A003X10
A003X11
A003X15
Is that possible??
Thanks in advance,
Mattia.
Community Browser