Full Outer Join?

KyJoLe — Tue, 07 May 2024 21:14:31 GMT

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

Re: Full Outer Join?

Vegar — Wed, 08 May 2024 03:42:50 GMT

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.

Re: Full Outer Join?

DGO — Mon, 13 May 2024 13:35:42 GMT

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

topic Full Outer Join? in App Development

Full Outer Join?

Re: Full Outer Join?

Re: Full Outer Join?