I’ve recently written a post on how to split a delimited string in SQL, now I need to do the reverse and take the flat table and create a delimited string. Fortunately creating a delimited string is far simpler than splitting a delimited string. Assuming we have a flat table called CountryUsers with the following structure: [...]
Apparently the query engine in Tableau 9 has undergone massive improvement. All I can say is I hope it's as good as implied in this article and, if so, well done Tableau!
I’ve just spent a reasonable amount of time digging through the internet to work out how to take a dataset containing a delimited string and then split the string to create new records. For example you could have a table called Users: Country User UK Bob|Fred|Bill USA Mike|Lou|Carol|Sam What you want to do is split [...]