Hi,
What I’m trying to do is essentially pick the last but one non-automated user from the event log and pull it to object level. The previous non-automated user needs to be different from the last non-automated user.
In the sample data shown below the desired output would be JANE.
I’ve tried looping one PU_LAST and using it as filter for another PU_LAST but doesn't seem to be working.
PU_LAST( OBJECT , EVENT_LOG , EVENT_LOG NOT IN (PU_LAST( OBJECT, EVENT_LOG,EVENT_LOG NOT IN (‘AUTOMATED’) )) , ’AUTOMATED’).
| EVENT LOG ID | USER |
|---|---|
| 1 | JACK |
| 2 | JANE |
| 3 | JOHN |
| 4 | AUTOMATED |
| 5 | JOHN |
Any insights would be much appreciated.