Combine 2 tables and keep both matched and unmatched items

[43918084]

I have below 2 tables that have same fields but different period.  I want to join them together to create a 3rd table for comparison purpose (please see the 3rd screen)

The combined table should join by [Arr Lcl Num Ath]. Those with same  [Arr Lcl Num Ath] should be in the same row as below

I would like to inquire if I can use outer join to achieve the above?  Many thanks in advance.

[Oliver_F · Accepted solution]

Hi,

you can do this using an outer join:  https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref....

If you need to qualify the fields like you did in your third screenshot (t0_ ; t1_) then you will have to add the [Arr Lcl Num Ath] field without any qualifikation to both tables so you can use it for the join.