Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
I would ask the same .. but placing NoConcatenate into the Load section seems to have done the trick .. not had to do it before ...
Hi Ralf,
So what if he aliased one of the Fields
so like
NewTable:
LOAD *,
Code as NewCode
RESIDENT Data
where Code <= 11;
DROP Table Data;
Then you would not need NOCONCATENATE, is that correct?
What's wrong with NOCONCATENATE? It's the better way, I think..
nothing wrong with NOCONCATENATE
just trying to get a better understanding of how it works, that's all!
Extra field would probably work but consumes more memory and time..
Excellent Ralf,
Thanks
Regards
Alan