Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can we sort on the names from A-Z in the script?
Hi
Try with "Order by"
Load * from tablename
Order by Name;
Hope it helps
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?
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.