Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
data_guru_001
Contributor III
Contributor III

Merge two Dimensions to Larger table

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!

 

Labels (3)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

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;

View solution in original post

2 Replies
Vegar
MVP
MVP

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
Contributor III
Contributor III
Author

Thank you!!!