I am using the “Find contacts at company” enrichment. I am saving the contacts into a new table. I would like to tho, to write an additional field to the table which values comes from the base table. But I cannot find the configuration for that.
To add an additional field to your new table when using the “Find contacts at company” enrichment, with values coming from the base table, follow these steps: 1. After running the enrichment and saving contacts to the new table, add a new column to the table. 2. Use the “write to table” feature to pull in data from the base table. You can do this by creating a lookup or formula column that references the original value from your base table. 3. If your tables are linked (which happens automatically when using Find Companies and Find People), you can extract attributes from the base table into your new table by mapping or referencing the relevant field. This approach lets you carry over any field from your base table into the new contacts table, ensuring your additional data is included alongside the enriched contacts.
What if in my base table there is second entry with the same company which “find contacts at comapny” would result in the same result but the addtional value changed. How can I make sure that in my people table the value will be overwritten?
To ensure the additional field in your people table always reflects the latest value from your base table (when there are multiple entries for the same company), rerun the lookup column in your people table after updating your base table. This refreshes the linked data, so the most recent value from the base table overwrites the previous one in the people table. If you add new columns or update values in the base table, force a rerun of the relevant column in the people table to sync the latest information automatically.
The problem here is, that the compnay lookup in my people table allways return the first entry. But I have two and I need the latest one
To ensure your people table returns the latest entry for a company when there are multiple entries in your base table, use the "Lookup Multiple Rows in Other Table" action. Set up the lookup to filter by the company identifier (like domain), and sort or filter the results to select the most recent entry—this may require using a date or timestamp field if available. This approach allows you to retrieve the latest matching row rather than just the first one. If you need to automate updates, use a unique identifier and set up your lookup accordingly.
I do not see sorting functionality in “Lookip Multiple Rows in Other Table”
The "Lookup Multiple Rows in Other Table" action does not support sorting or selecting the latest entry directly. It retrieves all rows that match your filter criteria, but you cannot specify which row (e.g., the most recent) to return if there are multiple matches. You can only filter by a single column at a time, not by multiple columns or with sorting. To work around this, you can: ** Retrieve all matching rows using the lookup. ** Use a formula column in your people table to process the returned list and select the latest entry based on a date or timestamp field, if available. If you need to always get the latest entry, ensure your base table has a unique identifier (like a timestamp) and use a formula to pick the most recent one after the lookup.
.png){kind=logo}
