Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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...
Hello Prashant,
I guess this will remove Name 1 with No.5 but I want the vice versa.