Hello All!
I am trying to perform a lookup between two datasets and I think the IF function is what I am looking for; but I'm unsure.
Task:
My first data set contains names of employees terminated from Company X.
The second data set contains names of employees hired at Company X.
Thus, I am trying to compare to see if an employee was terminated and re-hired in the same year (i.e. name = right_name) and term date < hire date.
This is what I have put in to the multi-field formula tool, but its not working:
IF [IGG] == [Right_IGG] &&
IF [Termination Dt] < [Right_Eff date]
THEN "false positive"
ELSE "true term"
ENDIF
If anyone has a solution it would be greatly appreciated (:
