5 Replies Latest reply: Aug 24, 2018 3:30 PM by Tyler Tollin RSS

    Where Exists() - Field not found

    Tyler Tollin

      I am having some trouble using a Where Exists when trying to load some data from a dimension table. Files A - C are used prior to this section to load data from extracts, and each have the Officer Code (or Primary Officer Number as shown) fields shown for the temp table.

       

      I am using a similar method in a QlikView application and it is working, so I am not sure what I am doing wrong. Any tips?

       

       

      tempOffList:
      Load
      "Officer Code"
      FROM fileA
      WHERE Today() - "Expire Date" > -30;
      
      
      Concatenate(tempOffList)
      Load
      "Officer Code"
      FROM fileB
      WHERE Today() - "Expire Date" > -30;
      
      
      Concatenate(tempOffList)
      Load
      "Primary Officer Number" as "Officer Code"
      FROM fileC
      WHERE Today() - "DOCUMENT EXPIRATION DATE" > -30;
      
      
      Concatenate(tempOffList)
      Load
      "Officer Code"
      FROM fileD
      WHERE Today() - "Covenant Expiration Date" > -30;
      
      Officer Table:
      LOAD
          Officer_cd as "Officer Code",
          Other Data
      FROM qvdA
      Where Exists("Officer Code");
      
      Drop Table tempOffList;