Hi,
I am positive this has been dealt with before but have not found a solution yet. We have about 6k websites that we are using on the dashboard as a Go to URL Action. What I’ve discovered is some work, some don’t etc and so I’d like to normalize them all using a calculation. The issue is, there are some with the beginning HTTPS, some don’t have it, some have www. Some don’t. It’s a hot mess of websites that I’d like to get all the same.
Any idea how to normalize them using tableau calculations? This data comes from a warehouse and users are not forced to enter it the same way...sigh..yes we are working on fixing that.
Attached is the excel sheet of about 30 with different web addresses and what we’d like to end up with in the last column.
Thank you
Tom
No reputable website should only have http://, and having checked a couple in your list, they appear to be omissions of the "s". Also, the vast majority of websites will automatically redirect abc.com to www.abc.com. On that basis, something like this REGEX might be suitable:
REGEXP_REPLACE([Website Url],"http(s)?(:)?(\/\/)?|(\/\/)?(www\.)?","")
You could add "https://" in front of it for the complete URL.
