Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
KyJoLe
Contributor

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

 

Labels (1)
2 Replies
Vegar
MVP

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.

DGO
Contributor III

@KyJoLe Is your data source SQL?  If so, you can write the query with an outer join.