I want to join two tables on Tableau. I don't want to lose any entries so I'm using a full outer join:
The data looks like this
Table 1:
Name1 Status Storage Certificate
gbo001 Running 16GB on
gbo003 Running 16GB on
gbo005 Running 16GB on
gbo006 Running 16GB on
Table2
Name2 Price
gbo001 10000
gbo002 12000
gbo003 12000
gbo004 16000
gbo006 11000
gbo007 14000
So I am using a full outer join, this is my query:
SELECT "Table_1"."name1" AS "name1",
"Table_1"."Status" AS "Status",
"Table_1"."Storage" AS "Storage",
"Table_1"."Certificate" AS "Certificate",
"Table_2"."Name2" AS "Name2",
"Table_2"."Price" AS "Price",
FROM "public"."Table1" "Table1"
FULL JOIN "public"."Table2" "Table2" ON ("Table1"."Name1" = "Table2"."Name2")
Strangely enough it is giving me same results as left join would:
Name1 Status Storage Certificate Name2 Price
gbo001 Running 16GB on gbo001 10000
gbo003 Running 16GB on gbo001 12000
gbo005 Running 16GB on null null
gbo006 Running 16GB on gbo006 11000
And these are the results I'd be expecting with a full outer join:
Name1 Status Storage Certificate Name2 Price
gbo001 Running 16GB on gbo001 10000
null null null null gbo002 12000
gbo003 Running 16GB on gbo003 12000
null null null null gbo004 16000
gbo005 Running 16GB on null null
gbo006 Running 16GB on gbo006 11000
null null null null gbo007 14000
Is it possible to adjust my query accordingly so I can see all existing entries from both tables?