Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
BTIZAG_OA
Contributor III
Contributor III

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