Increment Load

[Purushothaman]

Hi Qlik Experts,

I would like to perform a Increment load. Attached is my dataset. I would like to attach the below new data into my current data (EmpOff)  and perform a increment load.

New Data 

[Taoufiq_Zarra]

@Purushothaman  If I understood correctly, you want just to add this data : Input Only

you can just add line like :

Data:

LOAD EmpID, 
     [Last Name], 
     [First Name], 
     Title, 
     [Hire Date], 
     Office, 
     Extension, 
     [Reports To], 
     [Year Salary], 
     [Date Updated]
FROM
.\EmpOff.xls
(biff, embedded labels, table is Employee$);

NewData:
LOAD EmpID, 
     [Last Name], 
     [First Name], 
     Title, 
     [Hire Date], 
     Office, 
     Extension, 
     [Reports To], 
     [Year Salary], 
     [Date Updated]
FROM
C:\Users\admin\Downloads\New_data.xls
(biff, embedded labels, table is Employee$);

output:

[Taoufiq_Zarra]

@Purushothaman  If I understood correctly, you want just to add this data : Input Only

you can just add line like :

Data:

LOAD EmpID, 
     [Last Name], 
     [First Name], 
     Title, 
     [Hire Date], 
     Office, 
     Extension, 
     [Reports To], 
     [Year Salary], 
     [Date Updated]
FROM
.\EmpOff.xls
(biff, embedded labels, table is Employee$);

NewData:
LOAD EmpID, 
     [Last Name], 
     [First Name], 
     Title, 
     [Hire Date], 
     Office, 
     Extension, 
     [Reports To], 
     [Year Salary], 
     [Date Updated]
FROM
C:\Users\admin\Downloads\New_data.xls
(biff, embedded labels, table is Employee$);

output: