Clay Icon

Intermittent Bug in Full Name Function: Seeking Quick Fix

·
·

Been seeing this bug for over a year now and wandering if you aware or have a quick fix for me. The function clean full name is just a merge of the Clean first name (GPT) and clean surname (GPT). It sometimes (1 in 30) just stays blank. Any workaround? I’ve tried using the actual GPT result and also creating a results column but run into the same issue. https://app.clay.com/workspaces/341207/workbooks/wb_Aq9caTMAV5FK/tables/t_QusxM3BQZxDb/views/gv_EBD7afvszZ79

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey, The issue you’re seeing happens because merge or formula columns in Clay don’t process enrichment data that hasn’t fully loaded or are outdated. When I'm checking now it seems like the data isn't there anymore, was this planned?

    (279 kB)
    Image
  • Avatar of Channeled
    Channeled
    APP
    ·
    ·
  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.

  • Avatar of Jaydin P.
    Jaydin P.
    ·
    ·

    What is the correct way to set up a merge column of two AI columns (like in the example) to prevent this issue?

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey, The best way to prevent issues when merging two AI columns is to make sure the data in both is always up to date. You can do this by turning on Auto Update or manually re-running the columns if you’ve changed the prompt, source data, or any linked fields. Example of stale or outdated data: https://www.loom.com/share/1a9204dc588f42efa6fc84e26fcf0d13?sid=e6b02ed6-a2b5-4922-8b0d-2c8d2a7a0596 Let me know if you’d like help setting that up!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·