
Creator
2021-01-06
01:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Left join Qlik Sense
Hi, I have two dimension tables ( Table 1 and Table 2). I need to do Table 1 left join Table 2 and show all columns . How do I do this?
Note : The common element between two tables is Col 2. Just FYI - Col 1 from Dimension table is joined to Col 1 in the fact table.
Table 1:
Load
Col 1,
Col 2,
Col 3
FROM <qvd file>
Table 2:
Load
Col 2,
Col 4
FROM <qvd file>
14,601 Views
1 Solution
Accepted Solutions

Creator III
2021-01-06
01:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Table1:
Load
Col 1,
Col 2,
Col 3
FROM <qvd file> ;
Left Join (Table1)
Load
Col 2,
Col 4
FROM <qvd file> ;
14,595 Views
1 Reply

Creator III
2021-01-06
01:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Table1:
Load
Col 1,
Col 2,
Col 3
FROM <qvd file> ;
Left Join (Table1)
Load
Col 2,
Col 4
FROM <qvd file> ;
14,596 Views
