Join the Community

Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps

Community Guidelines

Powered by Tightknit

Troubleshooting Lookups Between Two Tables with Normalised URL

·

·

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?

Troubleshooting Lookups Between Two Tables with Normalised URL | Clay

Join the discussion

9 comments

Loading comments

Hunain F.
·
·
Happy to see that, Jonathan problem solved.
Nicole G.
·
·
Happy to hear that! Feel free to reach out with any additional questions you may have.
Jonathan M.
·
·
Yeah got it working thank you
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.
·
·
Thanks, will give that a go Tanveer H.
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.
·
·
https://app.clay.com/workspaces/573790/workbooks/wb_0syvbqvFgR62vdvv7v3/tables/t_0t05rfvydFoBXgjusfU/views/gv_0t05rfymBnuDJou94FR
Jonathan M.
·
·
yup i've checked all of that
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