Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How can we load excel data with specific field ascending order

Hi,

Can anyone explain me how can we load excel data with sorting specific filed.

Regards,

Sandeep

1 Solution

Accepted Solutions
its_anandrjs

Hi,

You have to use the resident table for the sorting or order by the table.

1. Load the excel file

Tab1:

Load Field1,Field2,Field3

From Excel;

Noconcatenate

Load

*

Resident Tab1

Order By Field3,Field2;//For sorting order

Drop Table Tab1;

Regards

Anand

View solution in original post

3 Replies
its_anandrjs

Hi,

You have to use the resident table for the sorting or order by the table.

1. Load the excel file

Tab1:

Load Field1,Field2,Field3

From Excel;

Noconcatenate

Load

*

Resident Tab1

Order By Field3,Field2;//For sorting order

Drop Table Tab1;

Regards

Anand

ecolomer
Master II
Master II

You can load excel file normaly and LOAD RESIDENT ordered by you

Anonymous
Not applicable
Author

Thank you. Its works for me.