Troubleshooting Column Merging Issues in Clay Tables

I'm struggling to merge columns as I have in one column in another table. The table where I've gotten this to work is here: https://app.clay.com/workspaces/346206/tables/t_Hizjx8bwPS3Z/views/gv_RihWVvEgrkCG and the column is "Email to Prospect". I'm trying to do the same in the "Final Email" Column of this table: https://app.clay.com/workspaces/346206/tables/t_9hqnt6t2GEu9/views/gv_hBomPZGZqFuN but for some reason, it just won't work. Any help will be much appreciated

7 comments

Channeled
APP
·
·
To merge columns in your "Final Email" column, follow these steps:1. Click "Add Column" > "Merge columns" 2. Input the formula to combine the two columns you want to mergeIf you're still experiencing issues after following these steps, you may want to:1. Check that the columns you're trying to merge have the appropriate data types 2. Verify the formula syntax you're using matches what worked in your "Email to Prospect" column 3. Ensure there are no formatting issues in the source columns Source: Hide, Re-order, Sort, Filter, Merge Columns
Owen C.
·
·
Hey Mark, thanks for reaching out and sorry to hear this isn't working as anticipated. Curious did you end up adding these formulas to the merge column? Or were these here by default? Also, what could be happening is that the Merge Column is working properly, except the Python column is returning a space leading the merge column to return this as copywriting when in fact there is no text. Would recommend adjusting the Python formula column to be a bit more precise. I'm not sure I understand how points 1 and 2 relate to one another within the formula and this may be leading to some of the issues found here. Hope this helps get the ball rolling on, would suggest changing the python formula to be a single logic formula instead of two bullets and then retry the the merge column. Let me know if you have any other questions here. :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1328055791/1e4eeff0c91ec87617dd1aa6e560/CleanShot+2025-01-09+at+12_04_58%402x.png?expires=1736530200&signature=c2caaf4ae3cb4c8ce593864554b1e6f2ef2bf9c21e69e87a5771d9270ef309a0&req=dSMlHsl7mIZWWPMW1HO4zQ%2FmVfIiawW92LbLPvXyNxS%2F%2FGBrWyDV3YuTztkm%0ANZymrHZz%2Bzxhl5HhZoM%3D%0A https://downloads.intercomcdn.com/i/o/w28k1kwz/1328070412/ac1a2c17b04549cb2fa547d2e7fa/CleanShot+2025-01-09+at+12_13_02%402x.png?expires=1736530200&signature=140ae2ddc5b4b09782e74afed0ed7238a8baaae6674de2e42a8e696675795a09&req=dSMlHsl5nYVeW%2FMW1HO4zbdy7%2Fe%2FjzWbH3VUDBL8X5s7G8DHS9xxe0BXGqbZ%0AkFkx1M%2BuaP0vfnrmfp4%3D%0A https://downloads.intercomcdn.com/i/o/w28k1kwz/1328068645/8840dd8867635ccbc61eeb5171ef/CleanShot%2B2025-01-09%2Bat%2B12_11_13-402x.png?expires=1736530200&signature=c5018ab3c2ccb434ee6691af7203d6fd0e7d5736b9363acbee08ce678b6ab974&req=dSMlHsl4lYdbXPMW1HO4zfFNov9rF3bGPY31k722Yjl0OYnVrc7shxSn4uDi%0ALKCcWwpFgkXD7WhdyU8%3D%0A
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.
Channeled
APP
·
·
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Mark S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
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.