I have a tableau worksheet that I'm building. I'm trying to parse out the row data that begins with "#" and then create a calculated field to use as a filter/parameter for the report. I tried creating a split but the result is not what I expected. The value on "#" can be anything. I am attaching the sample workbook.
IF CONTAIN([PPTInclude,"⌗Group1") THEN "Group 1"
ELSEIF CONTAIN([PPTInclude,"⌗Group2") THEN "Group 2"
.
.
END
Expected Results as Filter/Parameter:
#Group 1
#Group 2
#Group 3
#Group 4
.
.
There isn't a simple way (that I can think of) to create a list to fill a parameter.
This regex will grab the first item only. If you want to grab the others, they would have be unique columns for each row and you couldn't use as a parameter. If the list is known, you can do some join work to get the full list, but I guess if it was known you'd just fill the parameter with that.
REGEXP_EXTRACT([PPT Include], "#(\w+)")
To grab the other values you'd do something like...
