Clay Icon

Merging Sales Navigator Tables: How to Add Records to One Table

·
·

I have 2 tables, each from Sales Navigator searches. I meant to just add the records in table 2 to table 1, but for some reason Clay created a second table. Is there a good way to just add those records to table 1 now that they are in table 2? Ideally by just adding them to the "Find People from External List" column so that all the logic I've built in the table works as expected?

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hi there! To add records from Table 2 into Table 1, you can use Clay’s Write to Table feature. This will let you move records directly, so they appear in their respective fields. If those fields have an existing logic then yes it'll work as expected. Here are some guides to get you started: • Write to Table - Clay 101Write to Table Integration Overview Let me know if you need any help setting this up!

  • Avatar of Tanner B.
    Tanner B.
    ·
    ·

    Thanks, Bo. So I can see how to push any individual piece of data from Table B to Table A (email, linkedinprofile, etc...) - but is there a way to push the "Find People from External List" column from Table B to Table A, so that ALL of "nested data" from the Find People column appears in Table's Find People column, just as if they were part of the Sales Nav query that originally populated table A?

  • Avatar of Tanvi R.
    Tanvi R.
    ·
    ·

    Hey Tanner, so using Write to Table will create a new column for each of the fields that you map. However, if you're looking to have all of these fields nested in a single source column, here's a workaround you can apply: 1. Use write to table to send over either the email or LinkedIn profile column to the new table 2. Once you've sent this column to your new table, use the Lookup Single Row enrichment to conduct a Vlookup to pull all of the fields from that corresponding row into your new table. From here, you can see all of the properties in one source column and map out the fields that are important to you! Let me know if you need further assistance with this set up!

  • Avatar of Channeled
    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.