0 - 3 of 3 tags for lookup

Hi All,
Can anyone kindly let me know is it possible to perform look up in TPT ? I am having around 100K record in a file. I want to load it into a table by looking up another table(by joining a column between file and Table). Can someone kindly let me know is it possible. Thanks in advance!

I have 2 tables.
One has the test locations, columns are:
The second table has the info about the locations, columns are:

/*I have two views in a company’s HR database I am pulling from. 

One gives a list of hiring actions. The first time an employee is hired, they’re given a sequence of 1. Each time after they’re given a sequence of 2, 3, 4 and so on.

The second view I’m querying has similar information for employees who were terminated.