topic Concatenate historical data in QlikView

Concatenate historical data

qlikviewwizard — Mon, 13 Apr 2015 13:23:38 GMT

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 — Mon, 13 Apr 2015 13:28:02 GMT

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

qlikviewwizard — Mon, 13 Apr 2015 13:33:29 GMT

Could you give the script please?

Thanks.

MK_QSL — Mon, 13 Apr 2015 16:36:23 GMT

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

Colin-Albert — Mon, 13 Apr 2015 16:39:13 GMT

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 — Mon, 13 Apr 2015 16:51:08 GMT

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 — Mon, 13 Apr 2015 16:54:24 GMT

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

Thanks

BKC