Clay Icon
Join the Community
02 Support

Troubleshooting Table Merge Issues with Email and Mobile Numbers

Avatar of Bjorn C.Bjorn C.
·
·

hi there, I seem to have a bug in my table. could you pls check this and provide a fix? I have run a waterfall on both email + mobile numbers, but I'm not able to merge this nicely into 1 final column. I even have mapped the text columns of each email/mobile provider, and merge those together. It seems the 'Wiza Email' is never pulled into the merge. for the mobile number, I don't know why it's pulling nothing. This is my table - I indicated the issue columns in red: https://app.clay.com/workspaces/489926/workbooks/wb_22tSrxYmQVTB/tables/t_GSjgJH7YqzEQ/views/gv_36FrDDHQEmvu

4 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    The issue with your merge columns might be due to how the formula is set up. It's possible that the formula assumes there's a response for every row, which isn't always the case. This can lead to errors that prevent the merge column from returning the desired output. To fix this: 1. Modify your merge formula to include a condition that checks if the data exists before trying to merge it. For example, use an "if" statement to only action on the response data if it exists. 2. For the 'Wiza Email' issue, double-check that you've correctly selected and configured the Wiza integration in your table. Make sure you've chosen to add the email data as a column in your table settings. 3. For mobile numbers, ensure you've set up the "Find Phone Number" action correctly in your Wiza integration, providing the necessary information (name and company/domain or LinkedIn URL). If you're still having trouble after trying these steps, you may need further assistance to troubleshoot the specific formulas and settings in your table.

  • Avatar of Bjorn C.
    Bjorn C.
    ·
    ·

    Could you pls check inside my table - I tried all that, it seems to be a bug from my perspective. Even with Clay expert it was not solvable.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    I understand you're having trouble with the Wiza Email and mobile number columns in your table. Let's try a few more troubleshooting steps: 1. For the Wiza Email issue, double-check that you've selected the email data to be added as a column in your table settings. 2. For mobile numbers, ensure you've set up the "Find Phone Number" action correctly, providing the necessary information (name and company/domain or LinkedIn URL). 3. Try setting up an email waterfall. Go to "Add enrichment", type "Work email", click the waterfall, and select your preferred data providers. If these steps don't resolve the issue, you may need more in-depth assistance. Please request human support by clicking on "Talk to a person" for a detailed investigation of your specific table setup.

  • Avatar of Channeled
    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.