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;
You probably have to use
D_ShowAllBr:
NOCONCATENATE LOAD...
Try as below
D_ShowAllBr:
Load *
Resident D_ShowAllBrtmp
where [Entity ID] <= NUM(10);
Thanks Manish, but I have the same issue .. 0 returned values and no table created ..
As soon as I remove the where .. table creates with all values ..
you can try
D_ShowAllBr:
LOAD *
RESIDENT D_ShowAllBrtmp
where [Entity ID] <= 11;
DROP Table D_ShowAllBrtmp;
You probably have to use
D_ShowAllBr:
NOCONCATENATE LOAD...
Thanks, same result. No table.
does it returns no value or no table?
it seems you're missing a noconcatenate as you load *
EDIT:ops,I'mlate
Spot on and thanks ..
Why would he have to use NOCONCATENATE
If the Table is being Dropped?
Because it's appending to the already existing table (same structure), which gets dropped at the end. So, no data loaded at all...