how to do a conditional copy based on column data?
To perform a conditional copy based on column data, you can use our "write to table" feature with conditional run criteria. Here's how: 1. Set up a "write to table" action. 2. Select your source and destination tables. 3. In the optional step for conditional run criteria, input a formula that determines when the copy should occur. 4. The copy will only run if the formula evaluates to true. For more details on setting up conditional runs, check out our Clay University lesson on AI formulas and conditional runs. This approach allows you to transfer specific columns from one table to another based on certain conditions, keeping your data aligned and consistent.
i meant column to column copy based on conditions
To perform a column-to-column copy based on conditions in Clay, you can use our "write to table" feature. Here's how: 1. Set up a "write to table" action. 2. Select your source and destination tables. 3. In the column mapping step, choose the columns you want to copy from the source to the destination table. 4. Use the "Only run if" option to set conditions for when the copy should occur. This allows you to input a formula that determines when the action runs. The copy will only execute if your specified condition evaluates to true, giving you control over which rows are copied based on your criteria. For more detailed guidance on setting up conditional runs, check out our Clay University lesson on AI formulas and conditional runs.
yeah I got it. there is a formula module here which I used to get the data