Issue in Aggr and Set

[Anonymous]

Hi All.

I want to find the Destination on Max date for every Name .

AGGR and set behaving abruptly.

Regards

erika

[Gysbert_Wassenaar · Accepted solution]

Try MaxString(aggr(if(NUM=max(total <Name> NUM),Dest),NUM,Dest,Name))

[Anonymous]

Thanks Gysbert!!!!!!

[rajni_batra]

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

[Gysbert_Wassenaar]

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, ', ')

[rajni_batra]

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