Actually, I think I found the solution.
Not sure if it is new or I didn’t see it before.
When I switch to Text with tokens I can use the column for lookup from the table I want.
I haven’t tested it yet, though.
Hey!
Thanks for the response. In the Video I see the method of using the Lookup for Single or Multiple Records in one other specificTable.
In my case, I have the company_table_id and the company_record_id in each row and I want to make a dynamic lookup.
In the company lookup (my screenshot) I could do this.
It also feels more integer to use Ids for matching instead of the company_domain or the linkedin_url .
Is there a way to add the Company Lookup manually via Enrichments?
I only see a generic Record Lookup which does not seem to have Record ID access to match it.
Background: I am working on a workbook that writes people from one table to another and I need company data there to be updatable without the whole workbook to run.
Hey!
I want to dedupe two different tables based on a specific column.
Is there a way to do this?
Both tables contain Companies – one of them actually is just a list of company names and I want to know how many duplicates I have between the two lists.