I'm trying to move a column from one table to another if the website URL in one table matches the website URL in another.
I can easily lookup the website URL in one table and have it write if the website URL was found in the other table.
BUT, I cannot figure out how to write another column value in Table A to Table B if the website URL shown in Table A also exists in Table B
I've ready all of the articles, but getting stuck on how to write to table if a condition is met.
Table is here: https://app.clay.com/workspaces/566765/workbooks/wb_XDYtaWWEUGjZ/tables/t_BGRnEXAieuA7/views/gv_psJ7NuW88WVw
To conditionally write data based on matching URLs, use write to table with the "Only run if" setting:
Add a write to table enrichment in Table A
Select Table B as your destination
In Step 3, enter "/" to skip list selection
In Step 4, map the columns you want to transfer
In Step 5, configure "Only run if" to set your condition (e.g., only run if the website URL lookup column is not empty or matches) [1]
This ensures data only writes when your URL match condition is met. The "Only run if" setting controls when the enrichment executes based on specific data fields being filled. [2]
Was that helpful?
If you still need help with writing to table based on your condition, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific issues you’re encountering?
Doesn't work. I've been trying that. I must not be doing it right
I understand this can be frustrating. I’ll connect you to one of our human agents who can help you further.
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Hey David! What I'd recommend is to use a Lookup Multiple Rows action to search Table B for the website from Table A. This will return a positive result if a match is found. You can then use this output as a run condition (i.e. only run for those that don't find a match)
Hari K. Thank you. I don't think I was clear: I am trying to check if a domain listed in Table B exists in Table A. If that condition is true, I want to send the data for another column/row in Table A to Table B. Doing the check for the domain in Table A from Table B is easy. But what I'm having trouble doing is writing the data in Table A to Table B. The column I want to write is called "AI Classificiation". I've tried 'sent table data', but I can't get the run condition right. Workbook with tables is here: https://app.clay.com/workspaces/566765/workbooks/wb_XDYtaWWEUGjZ/tables/t_BGRnEXAieuA7/views/gv_psJ7NuW88WVw
Any help here?
Hey David! What I'd recommend is to instead use a "Send Table Data" action because it will allow you to send non-list object types.
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!
