How to combine 2 tables from different files into same filter panel

[Newbie_To_Qlik]

Hi All

I have 2 files (Table 2019 & Table 2020) and I would like to combine the Year 1 & Year 2 into (Year) to be use as filter panel in Qlik. Can anyone help on this.

Table 2020

Year_1	SI No	Activation Date
2020	CL10011	25-Jan-20
2020	CL10012	25-Jan-20
2020	CL10013	25-Jan-20

Table 2019

Year_2	SI No	Activation Date
2019	CL10001	25-Jan-19
2019	CL10002	25-Jan-19
2019	CL10003	25-Jan-19

[Kushal_Chawda · Accepted solution]

@Newbie_To_Qlik  Probably you need to append both the table into one as structure of the table looks similar like below

Data:
LOAD Year_1 as Year
     [SL No],
     [Activation Date]
FROM table1;

concatenate(Data)
LOAD Year_2 as Year
     [SL No],
     [Activation Date]
FROM table2;

 You can now use Year field for your filter selections