Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
Master II
Master II

Concatenate historical data

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;

1 Solution

Accepted Solutions
ramoncova06
Specialist III
Specialist III

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)

View solution in original post

6 Replies
MK_QSL
MVP
MVP

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

qlikviewwizard
Master II
Master II
Author

Could you give the script please?

Thanks.

MK_QSL
MVP
MVP

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
Specialist III
Specialist III

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)

balkumarchandel
Specialist II
Specialist II

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