This content has been marked as final. Show 15 replies
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
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;