Clay Icon

Linking Records in Write to Table Feature: How-To Guide

Β·
Β·

When using the write to table feature, how do you ensure the records in the table you write to are linked back to the parent table? I saw some videos on this but that step is left out.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    When using the "write to table" feature, you can ensure records are linked back to the parent table by following these steps: 1. Select the destination table you want to write to. 2. Choose the list of data from the parent table you want to send to the new table. 3. Define specific attributes from that list to send (e.g., Company Name, Domain). 4. Select additional data points from the current (parent) table to send along with the list items. By including data points from the parent table, you create a relational link between the two tables. This allows you to maintain the association between the original data and the newly structured information. Remember, "write to table" is designed for "1 to many" data relationships, ensuring data stays relationally linked between tables.

  • Avatar of Bo (.
    Bo (.
    Β·
    Β·

    Hey Malik, This would be done using the lookup feature. Lookup allows you to send a value that is the same in both tables, for example the domain, and you'll be able to use that domain to look up into the previous table to bring in the data.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·