How to Create a Consolidated Clay Table that pulls Data from 6 Different Tables in Salesforce

Due to limitations in salesforce (only being able to pull 2k accounts at a time), I've built 6 different clay tables to accomplish something I'm trying to do. Within those tables, I've narrowed them down to about 300 each. Is there a way to build a clay table that then pulls in the data from all 6 other tables?

✅1

5 comments

Imran J.
·
·
Oooo this is an interesting workflow, commenting to follow up on the solution, cheers
🙏2
Clay S.
·
·
just make 6 "lookup row in other table" columns :
✨1
Clay S.
·
·
🙂
Travers N.
·
·
I’m not sure that would work if I planned to do any additional enrichments to my new table as the companies would overlap, but maybe I misunderstand you and/or clay’s functionality
Eric N.
·
·
I would use Write to table to send all of the data to the main table
✨1