topic Re: How to use flag along with ID for incremental logic in App Development

How to use flag along with ID for incremental logic

abc_18 — Sat, 16 Nov 2024 03:33:20 GMT

Hello ,

I have to write an incremental logic based on ID and flag.

I am using date>modified date and for update using not exist (ID), but how to use flag along with that as flag is also getting update as Y or N based on update data.

How can I use this?

Thanks

Re: How to use flag along with ID for incremental logic

aapurva09 — Fri, 17 Jan 2020 08:59:33 GMT

Hi,

it would be helpful if you share some dummy data to understand your requirement better.

thanks

Re: How to use flag along with ID for incremental logic

abc_18 — Fri, 17 Jan 2020 09:07:08 GMT

For example below is the data set:-

ID	a	b	Key	Sales	Flag
1	4	5	9	4_5_9	Y
2	3	6	8	3_6_8	Y
3	25	7	7	25_7_7	Y

here ID field is incremental, now next day another record is being added, with a flag value as N, and first row of data is updated:-

ID	a	b	Key	Sales	Flag
1	4	5	9	4_5_9	Y
2	3	6	8	3_6_8	Y
3	25	7	7	25_7_7	Y
4	4	5	9	4_5_9	N

so to update the data in qlik, I will write where not exist(Key), but without flag it will not recognize that ID number'4' is a new records, so I have to include flag logic as well, because records are being updated based on that.

Re: How to use flag along with ID for incremental logic

aapurva09 — Fri, 17 Jan 2020 09:46:31 GMT

If I understood right, for each record if the Flag is 'N' its a new record, 'Y' is old. If this is correct, i would do the following:

Load today's table where we get records with Flag 'N' only and not exist(Key).
Replace Flag value from 'N' to 'Y'
Concatenate with existing qvd (your 1st table in the example).

Hope this helps

Thanks