Concatenate historical data

[qlikviewwizard]

Hi All,

I have 2014 data in Employee table (table: Employee_2014).

I want to concatenate the data Employee table daily.

This is the script I have written.

Please advise.

EMP:
LOAD * from Employee_2014;
concatenate (EMP)
LOAD * from Employee;

[MK_QSL]

IF you want daily data to be added in EMP table, use Incremental Load for Employee Table..

[qlikviewwizard]

Could you give the script please?

Thanks.

[MK_QSL]

It is difficult to give script for this.. If possible, try to find out Incremental Load in QlikCommunity..

[Colin-Albert]

Try loading all source tables with a wildcard

EMP: 

LOAD * from Employee_*;

This will load and concatenate all data from data sources Employee_2012, Employee_2013, Employee_2014   etc,

provided each source table uses the same field names.

[ramoncova06 · Accepted solution]

by concatenating the tables you will most likely be creating duplicates

probably what you want to do is add you current list of employees to the 2014 list, without adding the ones that already existed

if you have an employeeid you could do the following

EMP: 

LOAD *, EmployeeID as LegacyEmployeeID

from Employee_2014; 

concatenate (EMP) 

LOAD * from Employee

where not exists(LegacyEmployeeID, EmployeeID)

[Anonymous]

Hi see below link .. you will get multiple examples of incremental load

https://community.qlik.com/search.jspa?q=incremental+load&type=document

Thanks

BKC