How to best to handle duplicate relation key

jagjivvt — Thu, 07 Dec 2017 13:57:53 GMT

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

Re: How to best to handle duplicate relation key

Anonymous — Thu, 07 Dec 2017 14:30:09 GMT

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

topic Re: How to best to handle duplicate relation key in QlikView

How to best to handle duplicate relation key

Re: How to best to handle duplicate relation key