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.