data_guru_001
Contributor III
2019-03-29
11:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
934 Views
1 Solution
Accepted Solutions
Vegar
MVP
2019-03-30
01:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;
Table:
Load WK as Product
From Source;
JOIN (Table)
Load Color
From Source;
Vegar
Qlik Community MVP
Qlik Community MVP
923 Views
2 Replies
Vegar
MVP
2019-03-30
01:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;
Table:
Load WK as Product
From Source;
JOIN (Table)
Load Color
From Source;
Vegar
Qlik Community MVP
Qlik Community MVP
924 Views
data_guru_001
Contributor III
2019-04-01
03:15 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you!!!