How to Normalize URL in a Formula: Stop Losing Columns!

·

I’m loosing a lot of columns to having a normalise url enrichment ( after retrieving a url from an enrichment - is there a way to call the normalise url from within a formula?

3 comments

· Sorted by Oldest

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Ian M.
·
·
Another neat way to handle this would be a global parameter such that every time any enrichment returns a URL, it normalises it to a specific ( chosen ) format. And this then gets applied consistently and exhaustively so it becomes something I don’t have to worry about
Clay Team
APP
·
·
Hi Ian M. -- can you share a link to your table so I can better understand the issue here? If you're looking to retrieve information that is nested within an enrichment, you can do so like it's done here: https://www.loom.com/share/32ae94f5fee34a82b9fa739b53741d00?sid=f67d4463-1cac-477b-a82a-f2e0fe072cb6

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Ian M.
·
·
Another neat way to handle this would be a global parameter such that every time any enrichment returns a URL, it normalises it to a specific ( chosen ) format. And this then gets applied consistently and exhaustively so it becomes something I don’t have to worry about
Clay Team
APP
·
·
Hi Ian M. -- can you share a link to your table so I can better understand the issue here? If you're looking to retrieve information that is nested within an enrichment, you can do so like it's done here: https://www.loom.com/share/32ae94f5fee34a82b9fa739b53741d00?sid=f67d4463-1cac-477b-a82a-f2e0fe072cb6