Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All
I am unable to sort the Ukey field ..please assist. samplemodel attached.
It is sorted properly just promote you Ukey to above position and check ...
Check this
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.
Try this
Load
If(Count(previ....)>1,0,1) as Flag
from table
Group by fields;
Hello P M ,
the count and group by is not working
Hello P M ,
the count and group by is not working
sample attached.
what error you are facing?
I am getting Flag as all 0. please kindly see the sample model.
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 ....