Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everybody,
i'm trying to figure out a Boolean expression that checks if a field got a new entry.
Sort of field = field +1
I'm trying right nowto achieve this with:
if(field=field+1,-1.0) .
Of course it's not that easy. Lol.
Anybody who can help me here?
Cheers
spijatida
Are you trying to check in load statement that the current row field value is same as previous row value or not?
If Yes, then may be something like this, used strings as of now just for readability -
if(field=previous(field),'OldEntry','NewEntry') as Somefield
Actually I try to use that in the condition field when creating alerts