Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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