Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

san_qliklearn
New Contributor II

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

Tags (1)
1 Solution

Accepted Solutions

Re: How can we load excel data with specific field ascending order

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

3 Replies

Re: How can we load excel data with specific field ascending order

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
Honored Contributor II

Re: How can we load excel data with specific field ascending order

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

san_qliklearn
New Contributor II

Re: How can we load excel data with specific field ascending order

Thank you. Its works for me.

Community Browser