To extract data from one table using keys from a second table

I have two tables (excel) one table contains personid and employee id which also has name and firstname. The second table just has name and firstname and I want to extract the personid and employeeId from the first table using name and first name…
How can I do this? Which nodes?

Welcome to the forum @Colina.
This sounds like a job for the Joiner node.

Thanks for the welcome. I will have a look at the joiner node.
Thanks again.

I was looking at the reference filter node which does part of the job.

Yes. It does the job. I had forgotten about the joiner node.
Many Thanks.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.