Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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!!!