Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jagjivvt
Creator
Creator

How to best to handle duplicate relation key

Hi

I am looking for best way to handle duplicate keys. i am currently using the peek function that notes the first instance with and 1 and then adds a 1 to each duplicate record.

if(DSG_EEIDWE = Peek('DSG_EEIDWE'), Peek('DSG_EEIDWECTDSG')+1,1)as DSG_EEIDWECTDSG,

     if(DSG_EEIDWE = Peek('DSG_EEIDWE'), Peek('DSG_EEIDWECTDSG')+1,1)&DSG_EEIDWE as DSG_EEIDWE2

is there another way in QlikView to work this out.

thanks

Vijay

1 Reply
Anonymous
Not applicable

Hi ,

If you having duplicate column in Key Column means you can use the Rowno() function to make the duplicate records unique in case that's what you are looking for.

Or Else

Kindly attach the sample record so that we can able to understand what you really looking for