Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.