If you add a semicolon to the front of this string, you could probably leverage RegEx to extract all of the segments that follow the format ;_______| and once you do that, a simple split with a delimiter of | would separate out each substring. How the syntax of that RegEx looks I can't answer, but that's the idea that came to mind for me!
Do you need them all as separate coloumns? In each one there will be eg "Technology" as a value then.
If so you can first use a custom split for ";". You'll get 10 fields of the following scheme:
TRIM( SPLIT( [Test], ";", n ) )
(n is any value between 1-10)
You can then edit each calculation:
TRIM( SPLIT(SPLIT( [Test], ";", n ), "|", 1 ))
(the bold part is the part you need to add to each calculation - and you can get rid of the trim if you don't have any trailing or leading spaces)
If instead you just want to get rid of the string in between those bold words you can still use the calculation provided but add all together again with a "+"
I need them separate. I need to create something called Categories and each word should be in the Categories.
1 of 1 people found this helpful
See Vincents reply - if you are trying to do it in Tableau it is the most direct approach - If you have access to Tableau Prep - see my response - it would be the easiest-
or you can write some customer SQL to do it for you
Tableau will split only one field at a time using Split()
I have the solution in SQL, but it is not working on Tableau. My solution in SQL have the keyword DECLARE, and it is not working on Tableau. I cannot use Tableau Prep or Alteryx for that because I have the same problem with the DECLARE. I cannot create a SQL table in the database because I do not have admin for that. I need the solution in Tableau
I revisited the original query, and I could remove the keyword DECLARE from the query. Now, I have my categories. Thanks a lot.