Split function is not supported by many databases, you need to bring the data as it is in Tableau and then use other functions to have the required format.
Hope this helps to resolve your issue.
What you want to split ? Give some examples so that we can help
I have a field that has values like a;;b;;c;;d. I want to create new calculated fields having values a another having value b so on. The sizes of a,b aren't constant eg I can have hfkdshf;;rer;;rwerr;;wre or f;;wrer;;trettert;;tr. so in here I want calculated field1 to have values hfkdshf for 1st and f for second and so on.
Thanks in advance,
How many values can be present in your field separated by ; ? In your example there are 4 values. Will it be always four ? Do you want all 4 values to be extracted or only 1st ?
It can be more than four. But please answer the question assuming it is 4 i.e. I want 4 calculated fields with the first 4 values extracted.
Create 4 calculated fields. Hope this helps.
Split.twbx 9.4 KB