Combining Two Lists of Different Objects into One Unified List | Clay

Combining Two Lists of Different Objects into One Unified List

How can I take two lists of objects, that may have different properties, and combine them into a single list of objects with a single set of properties?

8 comments

Channeled
APP
·
·
You can merge columns in Clay by following these steps: 1. Click "Add Column" and select "Merge columns" 2. Input a formula to combine the two columns you want to mergeIf you need additional assistance with this process, please click on "Talk to a person" to get help from our support team. Source: Hide, Re-order, Sort, Filter, Merge Columns
Channeled
APP
·
Did that answer your question?
Mathew I.
·
·
no
Channeled
APP
·
·
I apologize for not meeting your expectations; would you like to rephrase your question or speak with our team for further assistance?
Mathew I.
·
·
person
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Bruno R.
·
·
Hi Mathew, thanks for reaching out! The 'write to other table' setup is the best approach here. You can create a destination table where records from the two reference tables are written and merged into one. Here’s how you can set up this enrichment: skip the 'Select a list' section and go directly to 'Add other data from table.' These are the properties you can merge into the final table as follows: 1. Make sure your Clay API key is linked correctly. 2. Select the columns you want to write to the table of reference, to merge the records in one unified table. https://downloads.intercomcdn.com/i/o/1198904364/78c2e80597d41d589143e455/CleanShot-2B2024-09-04-2Bat-2B23_00_35.gif?expires=1732219200&signature=bca8174a25549253b242920530b3ee52fd6e734c69335f6cbc7e6c649967f4d7&req=dSEuHsB%2BmYJZXfMW1HO4zWjfjMBFIp7KLP7nTaI26NlvlQ%3D%3D%0A You're all set! You can now save and run your 'Write to Table' column.
Channeled
APP
·
·
Hi Mathew I.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: