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

    Load Where - Resident issue

      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






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



      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;