Hi everyone,
I have a table where each Selected Customer Type has multiple countries associated with it. I want to display all countries in a single row, separated by commas.
For example:
- Currys → United Kingdom
- AO → United Kingdom, France, Germany, Italy, Poland
I tried { FIXED [Selected Customer Type] : MIN([Country]) } but this only returns one country.
I know Tableau doesn't have a native STRING_AGG equivalent, but is there any workaround to concatenate multiple string values into a single cell without writing separate calculations for each value?
Note: I don't have access to Tableau Prep, and my data source is SQL but Selected Customer Type is a calculated field in Tableau so I can't use Custom SQL for this.
Any help is appreciated, thank you!
#Tableau Desktop & Web Authoring
You may want to look at using table calculations to get the desired results. See if the attached workbook helps you.