15 Replies Latest reply: Apr 25, 2014 5:57 AM by Alan Farrell RSS

    Load Where - Resident issue

    robin Miller

      I have a table loaded within a script that is populated with some data not required - I want to limit the data by using the resident command to load a new table with a subset of the data.

       

      As an example the image below show a Entities and Entity ID's currently in the table - I want to reduce them to those with an [Entity ID] of less than 11

       

       

       

      Qlk_Entity.png

       

      I tried the following , but it returns no values into the new table

       

      D_ShowAllBr:

      Load *

      Resident D_ShowAllBrtmp

      where Match([Entity ID],'1' ,'2' , '3', '4', '5', '6', '7', '8', '9', '10');

       

      I have tried Wild Match and < 11 as an option .. each time I get an empty table

       

      I am unable to use the SQL in the initial query to limit it due to an issue with the adapter returning the data ..

       

      Any pointers please.

       

       

       

       

      Drop Table D_ShowAllBrtmp;