Skip to main content

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! 

How to concatenate string values in a single cell

 

 

 

#Tableau Desktop & Web Authoring

2 answers
0/9000