DSXchange

hi/hello,

how to perform flag values for duplicate records..

for example if i have
empid,sal,city
100,1000,chn
101,2000,hyd
100,3000,pune in i/p stage


i should get

empid,sal,city,flag
100,1000,chn,1
101,2000,hyd,1
100,3000,pune,0

in the output.. can anyone tell me how to do this..

use sort stage

use sort stage .set sort stage property --cluster key change Colum is true

surajkumar wrote:use sort stage .set sort stage property --cluster key change Colum is true

This would be the full answer.

You can also find the find occurances of the record using cluster key change Column like
if cluster key change Column =1 then first occurance