How to combine two columns into one column in tableau?

Question

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

Answer 1

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.