.png){kind=logo}
Best Method to Retrieve Different First Names from Another Table
If I'm pulling same records from another table, what is best way to pull the first names of one of the prospects that is different then the one in the current table
To pull the first names of prospects from another table, you can use our "write to table" feature. Here's how: 1. Go to "Actions" and select "Find people at these companies" 2. Choose your source table under "Companies" 3. Select the column containing company information (domain or LinkedIn URL) 4. Set your search parameters for the prospects you want 5. Click "Preview People" to check the results 6. If satisfied, click "Import" and "Save to new table" Once you have the new table, you can add the first name as a column to your current table: 1. Click on a cell in the new table's column 2. Hover over the "First Name" field 3. Select "Add as column" to bring it into your current table
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.
You have to use LOOKUP IN SINGLE ROW if you need one different person ...not multiple rows ..