How can we load excel data with specific field ascending order

[Anonymous]

Hi,

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

Regards,

Sandeep

[its_anandrjs · Accepted solution]

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]

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

[Anonymous]

Thank you. Its works for me.