Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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;

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

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;

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

data_guru_001
Contributor III
Contributor III
Author

Thank you!!!