I need to update table 1 records with table 2 data, specific to a record by a linkedin profile. UPDATE table1 SET table2 column2-x, column3=x, column4=x WHERE table1.colum1 = table2.column1 Is this possible?
Instead of using SQL queries directly, you can use Clay's built-in features to update records between tables: 1. Use the "Lookup Multiple Rows" integration to match records between tables based on the LinkedIn profile identifier. 2. Then use the "Enrich Person from Profile" feature to update the records with the desired information. This integration allows you to retrieve and update comprehensive details about an individual using their LinkedIn URL or User ID.Note that when enriching data from LinkedIn profiles, the process may take some time, especially for data older than 45 days, as it requires live retrieval from social profiles. Source: Enrich Person from Profile with Companies, People, Jobs
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!
Hey Lemuel, what other questions do you have? Looks like you're aware that SQL-like operations are not possible in Clay, and that the lookup operations will help you match between tables. Depending on the need, write-to-table could be a great option to make updates. https://www.clay.com/university/lesson/write-to-table-clay-101 https://www.clay.com/university/guide/write-to-table-integration-overview
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.