1 Reply Latest reply on Jul 14, 2018 10:41 AM by Yuriy Fal

    Find Missing Data values between 2 data sources

    Sanket Deshpande

      I have a scenario as follows . I have 2 excel files as follows:


      Master File 1:

      Name  Allocated desk


      tom     1

      matt     2

      john     3

      rob     4

      ....and so on


      Data File 2:


      Date      name      Desk worked


      Jan 1     tom          4

      jan 1     matt          1

      jan2       rob          2

      jan2       tom          1


      • What I want to achieve is I will have a date filter , I want to know on that specific day which members from the master file didn't work.
      •      For eg. on jan 1  'john' and 'rob' didn't work, so list should display only these names

      So what should be the join condition, on what fields . If blend then what fields etc.


      Kindly help.