Transpose interval FROM - TO

[#1]

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.