I feel like I'm having a brain dead moment. I've been scratching my head over this one...
Essentially, I want to perform a lookup command using the current events in my results. I realize I could generate a lookup table first, then perform my search using that lookup table, but that would complicate several aspects of a process I'm building which I would like to avoid.
employeeID employeeName managerID
000001 Doe, John 000002
000002 Doe, Jane 000003
000003 Bossman, Mr. -
I would like to create another field managerName, which looks at the current results of <... my_search>, finds where an employeeID matches a managerID, and reads employeeName as managerName. So I could get: