Finding a match between 2 unrelated tables

[Anonymous]

Hi All,

Running into a few road blocks here. Normally I'm a lookupvalue pro, but for some reason I am struggling.

I have two unrelated tables: Hires and Terms

On the hires table I want to create a lookup logic/measure to see if the new hire also shows up on the term table because they could have been a "no start" and if so, return a value of "Termed", otherwise "Active".  The reason why I need this is we only pull hires once a week and terms daily (I know, stupid) and we want to get a hold on who already termed. 

Sample data:

Active Table 

EE ID	Name	Title
1234	Claus, Stanta	Cheery Man
2345	Snowman, Frosty	Wintery Dude

Term Table

EE ID	Name	Title	Term Date
1234	Claus, Stanta	Cheery Man	12/26/2018
4564	Hog, Ground	Winter Screwup	2/3/2019

End Result (Would want to show on Active table)

EE ID	Name	Title	Status
1234	Claus, Stanta	Cheery Man	Termed
2345	Snowman, Frosty	Wintery Dude	Active

Many thanks!!

[parry2k · Accepted solution]

@Anonymous you can use lookupvalue function to see if value exists in term table or not and based on that you can create status column

[Anonymous]

@parry2k That's what I was trying to do, but could not get anything to work properly because the tables are not related and cannot be related.

[parry2k]

@Anonymous lookupvalue function doesn't need related table, it can work without related tables.

[Anonymous]

I figured it out. It was a punctuation problem. Oops.

[parry2k]

@Anonymous great so you used lookupvalue function, correct?