How to avoid duplicated record be loaded

[#1]

Hello,

I have problem with duplicated record need to be avoid during the loading. Below is the table source. When I load it into Qlikview, I want the first row of the duplicated record by key word to be loaded. So the result should be the table A at right. Please help.

[#2 · Accepted solution]

Thanks John,

If the Dispute ID is put in order, your approach works. I have used minstring() and it works right now. Thanks again your help.

[#3]

Did you tried it on QV10? As I posted before, I think that it doesn't work because Exists() change of behavior. I run John example in QV10 SR1 and it brings 4 records instead of 3.

[#4]

You are right. It does not work on QV10.

[johnw]

[quote user="Damián D'Onia"]John,

Your approach doesn't work on QV10. Check this http://community.qlik.com/forums/t/39497.aspx.

How annoying. Yet another failure to consider backwards compatibility when "upgrading" a feature. Way to go, QlikTech. Added my complaint to the other thread.