Can anyone explain me how can we load excel data with sorting specific filed.
You have to use the resident table for the sorting or order by the table.
1. Load the excel file
Order By Field3,Field2;//For sorting order
Drop Table Tab1;
Thank you. Its works for me.
You can load excel file normaly and LOAD RESIDENT ordered by you
Retrieving data ...