Moving Filtered Rows to a New Table in Clay: Best Methods Explained

Miguel A. · 2025-02-18T11:27:02.058853+00:00

Hello! How can I move filtered rows to another table in Clay? I want to ensure that only specific rows based on my filter criteria are transferred to a new table. What’s the best way to do this?

To move filtered rows to another table, you can follow these steps: 1. First, identify the specific rows you want to transfer by: • Using a checkbox column • Creating formulas • Filtering your list view by specific criteria 2. Then use the "Write to Other Table" feature to transfer the data: • Click "Add Enrichment" • Search for and select "Write to Other Table" • Specify the target Table ID • Map your columns from the source table to the destination table The Filter List of Objects feature can help you ensure only specific rows are transferred by: ** Selecting objects based on designated fields ** Setting your filter criteria * Specifying filter mode and values This approach will help you transfer only the rows that match your specified criteria to the new table.

Sources: Write to Other Table with Clay Labs Filter List of Objects with Clay

3 comments