Discussion Board for collaboration related to Qlik Education.
Can anyone explain me how can we load excel data with sorting specific filed.
Go to Solution.
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;
You can load excel file normaly and LOAD RESIDENT ordered by you
Thank you. Its works for me.