.png){kind=logo}
Troubleshooting Merge Column Feature Not Pulling Specific Column
I'm running into the issue of the "Merge column" feature isn't pulling one specific column. It works with all the rest though. Any ideas?
Bo (.··Hi, thanks for reaching out! Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1731452400&signature=9832cfe880c1cf5f0320969ca054c3ddba076aa30f2c3569cc3e175b10fd68e6&req=dSEgF85%2FmohWX%2FMW1HO4zYTywSr4A5US2BKsam%2FhVPsJZQ%3D%3D%0A This issue is often caused by stale data. Here’s what you can do: 1. Turn off the table and turn it back on. 2. Check out this guide for turning off tables, stopping ongoing runs, and setting row limits or filters: Loom video. 3. Learn more about stale or outdated data and how to address it here: Stale Data Example. Let me know if you need further clarification or help!
- Bo (.··
Thank you. Which columns are not working and which rows? Can you point it out to us?
Aly H.··The AI-Email-Valid column is supposed to be pulled in on the column named Merge1. It doesn't do that. Big picture overview is that AI finds the CEO name + email address. Then, that gets validated... and if not, it gets kicked through a waterfall sequence to find + validate an email address. The way I found this was an issue is that I had around 4k valid emails listed in the "AI-Email-Valid" column but wayyyyy less in the very first column (which is where all the valid emails get merged together).
- Bo (.··
Hi Ali! I recorded this video for you: https://cln.sh/7m2QXBWP. Let me know if you have any questions or need any further assistance. Have a great day!
- Aly H.··
No dice. I think we're on different pages. When I go to filters to have it only show me the rows where "Valid-AI-email" is not blank (as in there is a valid AI email), those emails should also be in Merge1 and Final-Email-CEO. They're not showing up there though. https://www.loom.com/share/c9d1610850de428e971934eb2b67fd2f
- Bo (.··
Hi Aly! I found the issue - you're experiencing stale datain your email validation workflow. To fix this, you can either: 1. Delete the "IcyPeas" column 2. Re-run the column 3. For faster results: turn off the table and force run all rows to trigger a fresh validation Here's a visual guide:cln.sh/bdLbpdSl This should properly sync your AI-Email-Valid data into your Merge1 column. Let me know if you need help implementing any of these solutions. https://downloads.intercomcdn.com/i/o/w28k1kwz/1250769391/f783890d44d5be31bfcde644f868/CleanShot+2024-11-13+at+_36TTAtMj5B%402x.png?expires=1731526200&signature=b8f3660a0f82865092022fafee88b2143beb022e00a4d55a5fcafcdae6447dbb&req=dSIiFs54lIJWWPMW1HO4zZanbgAjjch1d1RYX7ohXtJ%2B7SsyYPVHbbbhmlhN%0AQaLy%0A
