1 of 1 people found this helpful
One method might be to first split the "DAILY Weather" field with a space as the separator.
The brute force method would be then to have eight versions of your calculated field above,
one for each level of split, and then concatenate the results together.
A second method would be to pivot the data after the split, described here:
A third method would be to try to use Tableau Prep to perform the split and pivot.
Jessica and Charlotte Taft,
It is a custom split on space, then pivot, then convert to normal language using the calculated field above.
Here is the output
Attached in the Forum Thread are the tflx, twbx, and xlsx.