Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Troubleshooting Lookups Between Two Tables with Normalised URL | Clay

Troubleshooting Lookups Between Two Tables with Normalised URL

·Aug 08, 2025 10:13 AM·

I'm trying to do a look up between 2 tables using normailsedurl but it's not working, does anyone know why that might be?

9 comments

· Sorted by Oldest

Clay
APP
·
·
If your lookup between tables isn't working, try these troubleshooting steps: Force Rerun the Column: Click the column header and select Force Rerun Column to reset it. Delete and Recreate: If the issue persists, delete the affected column and create a fresh one, then re-map your data. Check Column Configuration: Ensure your Target Column, Filter Operator, and Row Value are correctly configured. The lookup can only filter using one column at a time. Note: Make sure "normalisedurl" is spelled correctly in your column name and that both tables contain the data you're trying to match.
Source: Lookup Rows | Documentation | Clay University
Jonathan M.
·
·
yup i've checked all of that
Jonathan M.
·
·
https://app.clay.com/workspaces/573790/workbooks/wb_0syvbqvFgR62vdvv7v3/tables/t_0t05rfvydFoBXgjusfU/views/gv_0t05rfymBnuDJou94FR
Tanveer H.
·
·
Make sure both columns are run through the Normalised URL enrichment first so they’re in the exact same format (https/http, no trailing slashes). Also confirm there are no hidden spaces. Once both are normalized, the lookup should work.
Jonathan M.
·
·
Thanks, will give that a go Tanveer H.
Nicole G.
·
·
Hi Jonathan- checking in here, were you able to figure this out? Let me know if you have any additional questions.
Jonathan M.
·
·
Yeah got it working thank you
Nicole G.
·
·
Happy to hear that! Feel free to reach out with any additional questions you may have.
Hunain F.
·
·
Happy to see that, Jonathan problem solved.