Efficiently Inserting Unique Values into a Target Table in Parallel Operations

·

Question- I have a table that generates a bunch of rows where the final column contains values that may be the same as multiple rows. I then want to write the value to another target table, but only if that target table doesn't already have that value and since the rows are generated in parallel the "lookup single row" doesn't really work... any tips?

3 comments

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.
Shawn S.
·
·
basically just looking for a way to do "many-to-one" mapping where i want to create a row in a new table for all instances of a specific value contained across rows of a column in the previous table