I think a calculated field on [Topics] will do this.
One way to do this (if I'm understanding your issue correctly) is like this:
IF [Topics] = "Brexit, France ... " THEN "Brexit"
ELSEIF [TOPICS] = "Brexit, Spain ... " THEN "Brexit"
ELSEIF... [additional categories go here]
In this way, you can create "buckets" of topics that are clean/consolidated for the view. The last line (else [topics]) will grab all the non bucketed data as-is.
Hope this helps!
There is a lot of "it depends" in this question.
Third row: Brexit, Economics, Global Business, European Union
What do you want to do with these four tokens on the line? Do you want to make 4 separate rows?
What do you want to do with tokens that mean the same thing, but are spelled differently? (Brexit vs brexit (lowercase) vs BREXIT)
What is the max number of tokens a line can have?
If you're just looking for a single token that can be anywhere in the string, you can use the CONTAINS() function.
Thanks for clarifying. In the third row as an example, I'd like to create 4 seperate rows and then combine all other instance of these topics into their respective row. Row three totals up to 6 sessions - I'd like to distribute those 6 sessions across each of the 4 topics.
Brexit: 6 sessions
Economics: 6 sessions
Global Business: 6 sessions
European Union: 6 sessions
Will Derek's formula work to accomplish that? Also, there shouldn't be any tokens that are spelled differently.
Tableau doesn't make rows.
You want to ETL your data with some utility that has an iterative capability to parse and write new rows.