Eliminate Duplicates in Qliksense

[Cbhuvi27]

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]

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]

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

I suggest you start looking at this page: https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

[Cbhuvi27]

Hello Prashant,

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