incremental load only based on ID column - Qlik Community

Anonymous · ‎2015-12-09

Hello Experts,

I have requirement like,

I have 2 months of data in my table and in that I don't have any date columns and having only ID column and rest of 60 columns.

It will be loaded with inserts and updates records daily. Here I want to update and inserts records in the current month only. Suppose if

ID

1.

is loaded in last month and also loading this month this should not update last month record. Again same record should be inserted.

Any way to achieve this requirement. Please help me on this experts.

Regards,

Kumar

Chanty4u · ‎2015-12-09

hi,

go through below link

hope this wil help u

Thanks

Suresh

Report Inappropriate Content · ‎2015-12-09

Your source have 2 rows or one row ? how the data populated to source ??

Anonymous · ‎2015-12-09

Hi,

Thanks for your reply.

my source is having only one row.

Regards,

Kumar