Updating Values in Clay Table Based on Matching Keys in CSV Uploads
Hi everyone, I am trying to achieve something that I feel should be very simple. But I don't get it to work. Every month I upload a CSV sheet into a clay table (table1). This data exists of scraped data. (I do delete all the rows afterwards, to prevent duplicated) The rows can either be new, updated or the same.
The new rows get send to the table2 -> that's easy.
Nothing happens with the non-updated rows.
With the updated rows, I want to check if a specific value (text columns) is equal or not to table2, based on a matching key (url). If not I want to update it.
"Send to other Table" doesn't work, because I take data from multiple sources (so it might already be existing) and the matching key is something else. I just want to update a value, based on a matching key.
