When you load two tables with the same data, you will only see one table loaded in QlikSense, but the number of data rows loaded will have doubled.
Basically what is happening is that Qlik is concatenating the data since all the fields are the same.
If you have different data but still the same field names, the tables will also be concatenated.
table1:
LOAD
STORE_CODE,
STORENAME,
STATE,
REGION
FROM [lib://Data/sample_data.xls]
(biff, embedded labels, table is ccomp$);
table2:
LOAD
STORE_CODE,
STORENAME,
STATE,
REGION
FROM [lib://Data/sample_data.xls]
(biff, embedded labels, table is ccomp$);
Environment:
Qlik Sense Enterprise on Windows
This is working as designed.
Resolution:
To not have the tables concatenate, you need to use NoConcatenate between the load statements.
In this case, you will have two exactly equal tables not concatenated, but a synthetic table will be created and join the two tables.
table1:
LOAD
STORE_CODE,
STORENAME,
STATE,
REGION
FROM [lib://Data/sample_data.xls]
(biff, embedded labels, table is ccomp$);
NoConcatenate
table2:
LOAD
STORE_CODE,
STORENAME,
STATE,
REGION
FROM [lib://Data/sample_data.xls]
(biff, embedded labels, table is ccomp$);