1 Reply Latest reply on Jun 16, 2019 4:12 PM by Peter Fakan

    How to join data on a field if 2 field values are the same and if not, join on another specific field?

    Jonathan Lam

      For example:

      Table 1:

      Header 1Header 2

      Table 2:

      Header 3Header 4


      If Header1 and Header2 are not equal, Merge with Header3 and Header4

      ElseIf Header1 and Header2 are equal, Merge with Header3 only.


      Anyway I can achieve something like this in tableau?