How to load using where and order by

[#1]

Hi

i want to load a  column emp_name from a table employees using order by and where clause.

where emp_id is 1,2,3.

orderby emp_id.

i need to load this through script

[its_anandrjs]

Try with this

tmpSource:

Load

*,

emp_id

From Location;

Noconcatenate

FinalTable:

Load

*,

emp_id

resident tmpSource

where Match(emp_id,1,2,3)

order by emp_id Asc;

Drop Table tmpSource;