Troubleshooting Issues with Merge Columns Feature in Software | Clay

Troubleshooting Issues with Merge Columns Feature in Software

I have a problem with the merge columns feature, normally it works great but today it doesn't work, I have columns with websites that don't appear in the merge column function. I tried a hard refresh CMD + SHIFT + R but dont work. I tried to create a new merge column and still doesnt work. Can you help me troubleshoot please?

19 comments

Clay
APP
·
·
Try these troubleshooting steps: Force Rerun the Column: ** Click the merge column header ** Select "Force Rerun Column" to reset it Check Formula Logic: ** Ensure your formula includes conditional logic like "if {{column_name}} exists..." to handle empty cells Create Fresh Column: ** Delete the problematic merge column ** Create a new merge column: Click "Add Column" > "Merge columns" ** Input your formula to combine the desired columns Filter and Merge Approach: ** Filter for rows where your website columns "is not empty" ** Run the merge on those specific rows * This helps avoid issues with empty data If the columns still don't appear in the merge function, the issue may be related to column dependencies or data loading delays.
Sources: Hide, Re-order, Sort, Filter, Merge Columns Table columns | Documentation | Clay University
Hari K.
·
·
Hey Elric - Just wanted to check in, were you able to figure this out?
Elric L.
·
·
no I just posted it, for now Im copying pasting what I need
Elric L.
·
·
so it doesn't solve my problem
Elric L.
·
·
Ill keep you posted if I can Hari K.
Elric L.
·
·
I tried to rerun, I tried the new merge column, it still doesnt work
Elric L.
·
·
sounds like it doesnt work with URL/links
Elric L.
·
·
but works with normal text
Hari K.
·
·
Hey Elric! Happy to help with this - can you send over the link to your table so I can take a look?
Elric L.
·
·
https://app.clay.com/workspaces/451915/workbooks/wb_0sxatjk4wHTzg9Rqipk/tables/t_0sxypywZADFCcB5gTWA/views/gv_0sxypywx4mnu5uDpXKK
Hari K.
·
·
Hey Elric! I believe the issue is because for a merge column to work well, you have to have inputs of the same data type for the output to flow. Hope this helps!
Elric L.
·
·
I have the same data type for darkhorses as glasspharm and it doesnt work for glasspharm
Elric L.
·
·
so not sure what's happening
Hari K.
·
·
I see! This is because the claygent column has not run yet, so the merge column is "waiting" for all inputs to either run or have not run due to a run condition to output. Hope this helps!
Elric L.
·
·
you're right!
Elric L.
·
·
it works now
Elric L.
·
·
I will know next time
Elric L.
·
·
thanks Hari!
Hari K.
·
·
Sounds good!
1