- In your worksheet, open the 'Analysis' menu then choose 'Create Calculated Field'.
- Change the field name to ‘CONCATENATE’.
- Enter the concatenate formula [field]+""+[field] and combine two fields into one. Then click 'OK'.
- Note: Ensure both fields in the calculated field share the same data type 'Abc'.
- Your aggregate data will appear in the Data pane.
- Drag the aggregated field to the Rows shelf, and the concatenated field will appear below.
How to Concatenate in Tableau
Follow this interactive demo to learn how to concatenate in Tableau.
📌 Why this matters
Concatenating fields lets you create meaningful identifiers and labels by combining separate data points—like merging first and last names or joining product codes with descriptions. This becomes particularly powerful when you're building dashboards for non-technical stakeholders who need context at a glance. Instead of showing separate columns that require mental assembly, you present complete, readable information. The real advantage emerges when filtering or grouping data, as concatenated fields often reveal patterns that aren't visible when values remain split across multiple columns.
Your product deserves an interactive demo
