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.6

      For example:

      Table 1:

      Header 1Header 2
      AB
      AA

      Table 2:

      Header 3Header 4
      AB
      AA

       

      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?