Re: Load. concatenate two excel and get a sorted output?
If the two excel tables have exactly the same number of fields and exactly the same names then the data will be appended into one table automatically. If that doesn't happen add a concatenate statement to the second load:
load * from ...excelfile1...;
load * from ...excelfile2...;
You can specify a sort order for most charts. See the Sort tab of the objects properties window. If you feel that you must do the ordering in the script then you need an additional resident load to sort the table: