3 Replies Latest reply: Feb 22, 2017 1:58 PM by Massimo Grossi RSS

    Script Help

    Mark Ritter

      I don't know if this is possible or even makes sense to do.

       

      But here goes.

       

      I want to create one table that contains all terminated employees and a second table that contains all active employees.  I have done that so far.

       

      Now the part I am not sure of.

       

      I want to create a third table that contains all of the terminated employees and only the active employees where there is no matching employee id in the terminated table.

       

      So far I have something like this:

      LoadTerms:

      Load Distinct Employee_ID

      From QVD where currentactive='0'

       

      LoadActive:

      NoConcatenate

      Load Distinct Employee_ID

      From QVD where currentactive='1'

       

      Next I want to combine them into a third table as I detailed above.

       

      Not sure how to do that.