topic Re: Eliminate Duplicates in Qliksense in App Development

Eliminate Duplicates in Qliksense

Cbhuvi27 — Fri, 15 Nov 2024 20:58:36 GMT

Hello All,

I am doing partial load and also have some duplicate records. How can we eliminates Duplicates when we are doing the partial load in Qlliksense.

For Eg:

Test:
Load *
Inline [
Name,No,User
Name1,1,AAA
Name2,2,BBB
Name3,3,CCC
];

Add Only
Load *
Inline [
Name,No,User
Name4,4,DDD
Name1,5,AAA];

Now I want to eliminate Name1 with No 1.

PrashantSangle — Sun, 12 May 2024 04:24:08 GMT

use where not exists()

try below

Test:
Load *
Inline [
Name,No,User
Name1,1,AAA
Name2,2,BBB
Name3,3,CCC
];

Add Only
Load *
Inline [
Name,No,User
Name4,4,DDD
Name1,5,AAA
]
where Not exists(Name)
;

Regards,

Prashant Sangle

Vegar — Sun, 12 May 2024 06:26:33 GMT

Qlik released a merge feature in 2021 that I believe can be of help for you.

Cbhuvi27 — Tue, 21 May 2024 10:01:38 GMT

Hello Prashant,

I guess this will remove Name 1 with No.5 but I want the vice versa.