Merge two Dimensions to Larger table

[data_guru_001]

Hello, 

Is it possible in Qlikview to take two different dimension fields, from two different tables, and merge them into one table with repeated values?

I have attached a screenshot of what I am trying to do. 

Thank you!

[Vegar · Accepted solution]

Yes you can do that with an full join. The following script will give you the desired output.

Table:
Load WK as Product
From Source;

JOIN (Table)
Load Color
From Source;

[data_guru_001]

Thank you!!!