13 Replies Latest reply: May 20, 2016 12:22 PM by Chris Kerr RSS

    Load if value exists in another table

    Chris Kerr

      In SQL I would accomplish my objective using the IN operator in conjunction with another select statement but I'm not sure how to do this in Qlikview.

       

      I have the following two tables.

       

      WorkforceInfo:

      LOAD

           EmployeeID

           Name

           PositionTitle

           PositionType

           OtherFields

      FROM

           MyQVD

      WHERE

           PositionType = 'Full Time'

      ;

       

      Exceptions:

      LOAD

           EmployeeID

      FROM

           MySpreadsheet.xlsx

      ;

       

      I need to load all records from my workforce info table where the position type is full time OR where the EmployeeID exists in my Exceptions spreadsheet. What is the best way to accomplish this?