Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in BI by (55.5k 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.

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers


94.7k users

Browse Categories