Recently I wrote 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 in SQL. Fortunately creating a delimited string in SQL is far simpler than splitting a delimited string. Assuming we have a flat table called CountryUsers [...]
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!
Ever need to split a delimited string in SQL, creating 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 is to split the string by the delimiter and create new rows: Country User UK Bob UK Fred UK Bill USA Mike USA Lou USA [...]