topic Re: Help with Incremental load with unique records in QlikView

Help with Incremental load with unique records

qlikuser222 — Sat, 16 Nov 2024 00:33:59 GMT

Hi All,

Can anyone please help me with Incremental load with unique records.

For example:

load * inline [
ID, unit, count, month, key, key2
123, 1, 1, 4,123114,123114
123, 1, 1, 4,123114,123114
123, 2,0,4,123204,123204
];

Concatenate
load * inline [
ID, unit, count, month,key,key2
123, 1, 1, 3,123113,123113
123, 1, 1, 3,123113,123113
123, 2,0,3,123203,123203
]
where not Exists(key2,key);

I need output with 6 records but I'm getting 5 records. How to handle this situation to get 6 records as output?

Thanks

Re: Help with Incremental load with unique records

YJ_SG — Tue, 02 Jun 2020 03:43:32 GMT

Add RowNo() when load. I modified inline table as below, it shows 6 records.

load * inline [
ID, unit, count, month, key, key2, row
123, 1, 1, 4,123114,123114,1
123, 1, 1, 4,123114,123114,2
123, 2,0,4,123204,123204,3
];

Concatenate
load * inline [
ID, unit, count, month,key,key2,row
123, 1, 1, 3,123113,123113,1
123, 1, 1, 3,123113,123113,2
123, 2,0,3,123203,123203,3
];

Re: Help with Incremental load with unique records

qlikuser222 — Wed, 03 Jun 2020 22:59:47 GMT

Thanks for your reply,

Unfortunately it still doesn't work and not giving me the expected results.

Is there anyway Qlik can handle situations like this?

Thanks

Re: Help with Incremental load with unique records

YJ_SG — Thu, 04 Jun 2020 00:41:04 GMT

check attached file

Re: Help with Incremental load with unique records

Saravanan_Desingh — Thu, 04 Jun 2020 00:48:41 GMT

Can you check this?

tab1: load *,ID&unit&count&month&key&key2 As Key3 inline [ ID, unit, count, month, key, key2 123, 1, 1, 4, 123114, 123114 123, 1, 1, 4, 123114, 123114 123, 2, 0, 4, 123204, 123204 ]; Concatenate (tab1) load * inline [ ID, unit, count, month, key, key2 123, 1, 1, 3, 123113, 123113 123, 1, 1, 3, 123113, 123113 123, 2, 0, 3, 123203, 123203 ] where not Exists(Key3,ID&unit&count&month&key&key2);

Re: Help with Incremental load with unique records

qlikuser222 — Fri, 05 Jun 2020 02:26:52 GMT

Thanks For your reply,

If I use the below code I get expected results, but when I run the Qlik again by loading Tab1+tab2 results in QVD and concatenating it with Tab3 (which has tab2 data) it gives me duplicates and end result would be like below

ID, unit, count, month, key, key2,Key3

123, 1, 1, 4, 123114, 123114, 1231 1 4123114123114
123, 1, 1, 4, 123114, 123114,1231 1 4123114123114
123, 2, 0, 4, 123204, 123204,12320 4123114123204
123, 1, 1, 3, 123113, 123113, -
123, 1, 1, 3, 123113, 123113, -
123, 2, 0, 3, 123203, 123203, -

123, 1, 1, 3, 123113, 123113, -
123, 1, 1, 3, 123113, 123113, -
123, 2, 0, 3, 123203, 123203, -

How to avoid getting duplicates , please help.

Thanks