Not sure how to get into one field just using Tableau but three regex extracts would separate them. You could try split and pivot if you have access Tableau Prep, but I haven't tested doing that.
URL1 = REGEXP_EXTRACT([URL], "(.*)\n")
URL2 = REGEXP_EXTRACT([URL], "\n(.*)")
URL3 = REGEXP_EXTRACT([URL], "\n.*\n(.*)")
Hope this helps, if so please mark correct/helpful so others may find.
Thanks Nick. This is a cool technique but it would not be feasible for me to create a new column for each URL because my real data can have up to 104 different URLs.
Yeah, this definitely wouldn't work then. You'll need to split and pivot with a data prep tool before bringing it into Tableau then.
A very relevant thread here. The URL Media situation is a big deal as more users are trying to replicate classical MS Office table situations. Me included, obviously.
I believe the Action>URL will treat the table as an aggregation only, or one single object?
Is there a method to treat each row value as a unique ACTION>URL item?
I will play around with the REGEX function, too.
Richard, you can add a field to the url of a URL Action. That field can be the whole url or just part, like the querystring. This can be a unique value for each mark, or row in the data for the viz. In the below example Url is a calc field where I build the entire url because it is unique for each row.