Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (55.6k points)

Can anyone tell me how to combine two columns into one column in tableau?

1 Answer

0 votes
by (119k points)

If both columns are integers you can do this calculation:

ZN (Left ID) + ZN(Right ID)

If both columns are alphabetical characters, you can do this calculation:

TRIM (IFNULL(STR([Left ID])," ")+ IFNULL(STR([Right ID]," "))

I would recommend doing the first calculation if possible because integers will be processed much faster compared to strings. Later, you can just filter on that field.

If you want to learn Tableau, check out this Tableau Certification Course by Intellipaat.

Browse Categories