Aggr Function Help

[Anonymous]

I am trying to flag '1' when there is Operation/Transaction of  "Reschedule or Route" for the first time in a given Task ID (as shown in the above) and then sum the number of such records for each LockedBy_IR in separate column.

In the above example, the sum for TGARCIA should be 1 and 0 for rest of the LockedBy_IR.

Any help will be really appreciated.

Thank you in Advance.

[ogautier62]

Hi,

try this :

if(row_counter =

aggr(nodistinct min(if(operation = 'route' or operation = 'reschedule',row_counter)),task_id),

1,0)

regards

[sunny_talwar]

Would you be able to share a sample to have a look and test it out?

[Anonymous]

I won't be able to share data.

I am sorry, for late response I didn't get the notification email about the comments on my thread.