Unable to sort Ukey

[suvechha_b]

Hello  All

I am unable to sort the Ukey field ..please assist. samplemodel attached.

[prma7799]

It is sorted properly just promote you Ukey to above position and check ...

[prma7799]

Check this

[suvechha_b]

Thanks ,

Please kindly let me know how to Flag =1 when occurance is one . Highlight in red .

But zero where occurance is twice , say 849 compare previous row 849 then flag 0.

Thanks in advance.

[prma7799]

Try this

Load

If(Count(previ....)>1,0,1)  as Flag

from table

Group by fields;

[suvechha_b]

Hello P M ,

the count and group by is not working

[suvechha_b]

Hello P M ,

the count and group by is not working

sample attached.

[prma7799]

what error you are facing?

[suvechha_b]

I am getting Flag as all 0. please kindly see the sample model.

[prma7799]

Try this

OpenUser_final3":

NoConcatenate

LOAD

DateJoinKeyPL, 

  deal1, 

     dealnm1, 

     previousdealid,

if(count(previousdealid)>1,1,0) as FlagLateststate

Resident "OpenUser_final2"

GROUP BY DateJoinKeyPL, 

  deal1, 

     dealnm1,    

     previousdealid;

Or please share some sample data ....