Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All.
I want to find the Destination on Max date for every Name .
AGGR and set behaving abruptly.
Regards
erika
Try MaxString(aggr(if(NUM=max(total <Name> NUM),Dest),NUM,Dest,Name))
Thanks Gysbert!!!!!!
HI Gysbert ,
We tried this expresion but this is taking lot of Time and RAM on actual data to process..
Is there any other to optimize it or other suggestion!!!
Any help would be appreciated..
Regards,
rajni batra
Do the calculations in the script:
T1:
LOAD Date,
num(Date) as NUM,
Month(Date) as Month,
Dest,
Name
FROM ...etc
join load Name, max(NUM) as NUM, 1 as Flag
Resident T1
group by Name
Then use the new Flag field in the expression:
concat({<Flag={1}>} Dest, ', ')
Hi Gysbert,
Thanks for your reply, Can't do it in scripting as max value is based on User selection,
I have tried something(basically trying to remove IF) which is working fine in some conditions..
like it is not working for current selection i have made but if i will clear that it gives fine output,
Please check if you could help in that...
Regards,
Rajni