topic How to load updated records in QlikView

How to load updated records

sanjujeeboy — Sat, 16 Nov 2024 00:45:54 GMT

Hi All,

I have a table named Old , which is loaded in Qlikview. Now these values gets updated and my requirement is : the table should be updated with new values as in table new. How could i achieve this

New
Date	Campaign	Leads
4/16/2020	A	50956
4/17/2020	B	7078
4/18/2020	C	51248
4/19/2020	D	7740
4/20/2020	E	2100


Old
Date	Campaign	Leads
4/16/2020	A	50956
4/17/2020	B	6568
4/18/2020	C	49378
4/19/2020	D	7660
4/20/2020	E	1908

Re: How to load updated records

Saravanan_Desingh — Wed, 29 Apr 2020 02:19:42 GMT

One solution is:

tab1: LOAD *, 2 As File INLINE [ Date, Campaign, Leads 4/16/2020, A, 50956 4/17/2020, B, 7078 4/18/2020, C, 51248 4/19/2020, D, 7740 4/20/2020, E, 2100 ]; Concatenate LOAD *, 1 As File INLINE [ Date, Campaign, Leads 4/16/2020, A, 50956 4/17/2020, B, 6568 4/18/2020, C, 49378 4/19/2020, D, 7660 4/20/2020, E, 1908 ]; Left Join (tab1) LOAD Date, Campaign, Max(File) As File_Max Resident tab1 Group By Date, Campaign ; tab2: LOAD Date, Campaign, Leads Resident tab1 Where File=File_Max ; Drop Table tab1;

Re: How to load updated records

Saravanan_Desingh — Wed, 29 Apr 2020 02:24:19 GMT

Adding a data which doesn't have New record.

tab1: LOAD *, 2 As File INLINE [ Date, Campaign, Leads 4/16/2020, A, 50956 4/17/2020, B, 7078 4/18/2020, C, 51248 4/19/2020, D, 7740 4/20/2020, E, 2100 ]; Concatenate LOAD *, 1 As File INLINE [ Date, Campaign, Leads 4/16/2020, A, 50956 4/17/2020, B, 6568 4/18/2020, C, 49378 4/19/2020, D, 7660 4/20/2020, E, 1908 5/1/2020, F, 100 ]; Left Join (tab1) LOAD Date, Campaign, Max(File) As File_Max Resident tab1 Group By Date, Campaign ; tab2: LOAD Date, Campaign, Leads Resident tab1 Where File=File_Max ; Drop Table tab1;