topic Re: we need latest modified record from Database based modified time and Primarykey: in QlikView

we need latest modified record from Database based modified time and Primarykey:

Srinivas — Tue, 03 Feb 2015 06:03:36 GMT

Dear Friends,

I have one query

When we are extraction from data base that data should be based on primary key and creation date we are pinking the data.Here one query primary key may be may not be same but we need to pick latest modified record that's depend on time , This latest modified record based on time we will knows.

see below screen shot for understanding :

here my output is below one because those are latest modified records:

Advance Thanks,

Munna

Re: we need latest modified record from Database based modified time and Primarykey:

deepakqlikview_123 — Tue, 03 Feb 2015 06:11:19 GMT

I will suggest you to use where not exist clause by using primary key in your script.

Thanks

Re: we need latest modified record from Database based modified time and Primarykey:

Srinivas — Tue, 03 Feb 2015 07:47:32 GMT

Hi Frds,

all most got the solution through below code

Thanks,

Munna

Re: we need latest modified record from Database based modified time and Primarykey:

Srinivas — Tue, 03 Feb 2015 07:48:53 GMT

Thanks for your valuable suggestion Deepak,

Regards,

Munna