Clay Icon
Join the Community
02 Support

Using Claygent to Fill Incomplete Address Data Efficiently

Avatar of Edmund C.Edmund C.
·
·

If I have a column that has incomplete data, say an address column where coverage is 50%. Question: Can I run claygent to find the address and add the result to the ORIGINAL address column if the field was blank? I dont want to overwrite good data, so can use a only run when original field is blank.

4 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Yes, you can use Claygent to find and add addresses to your original address column without overwriting existing data. Here's how: 1. Set up a Claygent prompt to search for addresses. 2. Define column outputs in the Claygent pop-out modal. 3. In your prompt, instruct Claygent to output the found address to the 'Address' field. 4. Use a formula to combine the original and Claygent-found addresses: =IF(ISBLANK([Original Address]), [Claygent Address], [Original Address]) This approach will keep existing data and only fill in blank fields. If you need more assistance, you can request human help by clicking on "Talk to a person" in this chat.

  • Avatar of Edmund C.
    Edmund C.
    ·
    ·

    It said I'm creating an infinite loop

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To use Claygent to fill in blank address fields without creating an infinite loop, follow these steps: 1. Set up a Claygent prompt specifically for finding addresses. 2. In the Claygent pop-out modal, define the column outputs. 3. Create a new column for the Claygent results, separate from your original address column. 4. In your spreadsheet, use a formula to combine the original and Claygent addresses: =IF(ISBLANK([Original Address]), [Claygent Address], [Original Address]) This approach keeps existing data, only fills blank fields, and avoids infinite loops. If you need more help, you can request human assistance by clicking "Talk to a person" in this chat.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·