8 Replies Latest reply on Sep 30, 2013 12:09 AM by Yuriy Gavrilov

    How to compare data in two columns ?

    . Apnea

      Hi,

      How do you compare data in two columns and display the difference in tableau. I used to do it in Excel, but the not able to find the appropriate functions.

       

      Example:

              

       

      Column AColumn B
      DataXDataY
      DataX1DataX2
      DataX2DataY1
      DataYDataX1

      DataY2

       

       

       

      The objectIf is to to dispaly the result in 3 Columns

       

      Data in CommonData In Col B but Not in Col A
      Data In Col B but Not in Col A
      DataX2DataY1DataX
      DataX1DataY2

       

       

      Thanks for you help,