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)
Profile | From | To |
---|
A001 | X10 | |
A002 | X11 | X18 |
A002 | L12 | |
A003 | M5 | X15 |
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 1 | Header 2 |
---|
A001 | X10 |
A002 | X11 |
A002 | X15 |
A002 | X17 |
A002 | X18 |
A002 | L12 |
A003 | M5 |
A003 | X10 |
A003 | X11 |
A003 | X15 |
Is that possible??
Thanks in advance,
Mattia.