1 Reply Latest reply on Nov 28, 2018 10:37 AM by Jennifer VonHagel

    Need Help!!! Compare the data from 3 excel sheets and return the data that are not available.

    Allwin Manoj

      Hi All,

       

      I'm having 3 excel sheets.

      1. DB_Inv SS
      2. DB_Inv SF
      3. DB_Inv BP

       

      DB_Inv SS is the master file will have all the invoice numbers.The Master file invoices need to compare with other two sheets (DB_Inv SF,DB_Inv BP) and find the missing invoice numbers.

       

      Used left join and filtered NULL to get the desired output. But went unsuccessful.

      Left join.PNG

      Using 2018.1 version

       

      Expected Output

      output.PNG

       

      Due to restrictions i can't able to attach the workbook. So attached the sample data in spreadsheet.