Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
BTIZAG_OA
Creator II
Creator II

Specify deleted rows on incremental load

Hello everyone,

I have a app which has icnremental load (delete+insert).

I need to specify deleted rows with flag how can i achive it?

my script is like


//FullLoad
data:
load
date
key
field1,
field2
from db;
store * into data.qvd;

//vupdatedate
tab:
load 
max(date) as maxdate
resident data;
let vdate = peek('tab',*,'maxdate');
drop tables data,tab;

//Incremental
incremental:
load 
date
key
field1,
field2,
0 as Deleted
from db
Where date > $(vdate );

Concatanate
*
from data.qvd;

From here i need to fetch deleted rows and concatanate it to incremental table with "1 as Deleted" field(flag)
how can i achieve this???

0 Replies