
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Full Outer Join?
Hello everyone,
I have two similar tables that I want to do a full outer join on to become one. I want to include all fields from both tables where there is a match and create a column that explains whether the row is on the left table, both tables or right table. I've looked this up both the other questions in the community don't work for me. Example data below.
Server Warehouse:
Warehouse ID | Warehouse Name | Warehouse Manager | Warehouse Description |
WH1 | Cleveland_Main | John | This warehouse stores servers and is managed by John. |
WH2 | Richmond-1 | Bill | Warehouse for servers. |
WH3 | WH300 | Adam | Adam's warehouse. |
Database Warehouse:
Warehouse Code | Warehouse ID | Address | Assets | Status |
A382 | WH1 | 11125 Third St. | 201,362 |
Active |
B392 | WHID9 | 234 Reading Rd. | 580,122 | Active |
B555 | Ware2 | 8249 Foster Ave. | 586,322 | Inactive |
Expected Outcome:
Warehouse ID | Warehouse Name | Warehouse Manager | Warehouse Description | Warehouse Code | Address | Assets | Status | Group |
WH1 | Cleveland_Main | John | This warehouse stores servers and is managed by John. | A382 | 11125 Third St. | 201,362 | Active | Server and Database Warehouse |
WH2 | Richmond-1 | Bill | Warehouse for servers. | Server Warehouse | ||||
WH3 | WH300 | Adam | Adam's warehouse. | Server Warehouse | ||||
WHID9 | B392 | 234 Reading Rd. | 580,122 | Active | Database Warehouse | |||
Ware2 | B555 | 8249 Foster Ave. | 586,322 | Inactive | Database Warehouse |

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe if you do it in two steps.
//Step 1 (join the tables and adding some new fields)
Warehouse:
Load *, 1 as in_server_warehouse
FROM [Server Warehouse];
Join (Warehouse) LOAD *, 1 AS in_database_warehouse
FROM [Database Warehouse];
//Step 2: make your desired new field by using the info found in the in_server_warehoue and in_database_warehouse fields.
Qlik Community MVP

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@KyJoLe Is your data source SQL? If so, you can write the query with an outer join.
