Lookup Multiple Rows in Another Table for Entire Column Data

Clay S. is there a way to use "Lookup Multiple Rows in Other Table" where it receives all the information from an entire column vs just one specific cell

4 comments

Channeled
APP
·
·
The "Lookup Multiple Rows in Other Table" action in Clay doesn't directly support retrieving information from an entire column. This action is designed to look up multiple rows based on a specific filter criteria. When using this action, you can only use one column at a time to filter your search. The action requires you to specify: 1. The table to search 2. A target column 3. A filter operator 4. A row value to match 5. An optional limit for the number of rows to return If you need to work with entire columns of data, you might consider using our "write to table" feature or exploring other data manipulation options within Clay. For more specific needs, you may want to request human assistance for a tailored solution.
Sources: Lookup Rows | Documentation | Clay University Lookup Multiple Rows in Other Table with Clay Lookup Rows | Documentation | Clay University
Adam A.
·
·
am i able to write to table and add to my current cells vs adding now rows?
Channeled
APP
·
·
The "write to table" feature in Clay is primarily designed to add new rows to a table rather than modifying existing cells. However, you can use it to update existing data by following these steps: 1. Select your Clay account 2. Choose the destination table (the one you want to update) 3. Skip list selection by entering "/" 4. Map the columns you want to update from your source table to the destination table This process will essentially overwrite the existing data in the mapped columns of the destination table with the new data from the source table. If you need more specific data manipulation options, you might want to explore other features or request human assistance for a tailored solution.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University
Channeled
APP
·
·

Lookup Multiple Rows in Another Table for Entire Column Data | Clay