Find a duplicate entry with a certain value

Anonymous — Tue, 18 Sep 2018 12:29:19 GMT

Hello

I am flagging (FLAG) an entry according to an if comparing a mapping table to a value

some of the entries have duplicate NAME

Of every duplicates of the same NAME, only 1 can be flagged FLAG

--> I want to FLAG every NAME duplicates with the FLAG

So I think I need to loop through every duplicate of the same NAME to check if there is one entry with the FLAG

And if yes, Set the FLAG to every duplicate entry of the same NAME

I check for duplicate like this

If(Exists("NAME"),'Duplicate') as Duplicate,

further down the same LOAD I apply my FLAG like this

if(applymap('map_Refarticle',"Num article")<>"NUM OF ARTICLE" ,0,1) as FLAG,

--> How can I ?

- loop through every Duplicate of each kind to find out if one of them has FLAG

- and set the FLAG to all of them if true

I guess this is a bit of an message in a bottle but hey, I just stuck so I try

plus explaining the problem here is always a plus to understand it better :]

cheers

guys

topic Find a duplicate entry with a certain value in QlikView