Sort on names from A-Z

[#1]

Can we sort on the names from A-Z in the script?

[MayilVahanan]

Hi

Try with "Order by"

Load * from tablename

Order by Name;

Hope it helps

[#3]

Hi, i have the dataset about couple of hundred thousand records using the "Order by" might get me the order thats needed, but i am worried about the script execution time do you think it might affect the execution time i know for sure that "groub by" does affect the execution time?

[Gysbert_Wassenaar]

It does affect execution time but with a hundred thousand records that shouldn't make much difference. First you have to load the data into a table and then do another resident load to sort the data:

Temp:

load * from sometable;

Result:

load * resident Temp

order by Name;

If you get your data from a database you can have the database sort the data for you:

Result:

SQL select * from sometable

order by Name;

The database will also need time to sort the data, but it may be faster. You'll have to test which option is the optimal solution.