Import data

[Carlaf_93]

Good morning,

i have two tables with the same dimensions that contains data fo two different years.

For example:

[TABLE1]: // In data there are the values for 2020

LOAD 

DATA, 

VALUE,

CODE,

DESCRIPTION,

CUSTOMERS

from [lib:table1];

[TABLE2]: // In data there are the values for 2021

LOAD 

DATA, 

VALUE,

CODE,

DESCRIPTION,

CUSTOMERS

from [lib:table2];

I would like to import this as a single table, how can i do it without having strange data?

[Or]

If you load these two tables and they have exactly the same fields, Qlik will automatically load them as one table. You don't even have to do anything...

If they don't already contain the year, you may want to add a hard-coded 2020 as Year and 2021 as Year respectively to your loads.

[Saravanan_Desingh]

May be, try like this.

[TABLE1]:
LOAD 
DATA, 
VALUE,
CODE,
DESCRIPTION,
CUSTOMERS,
2020 As Year
from [lib:table1];

Concatenate(TABLE1)
LOAD 
DATA, 
VALUE,
CODE,
DESCRIPTION,
CUSTOMERS,
2021 As Year
from [lib:table2];