how to sort fields according to my own choice

[#1]

how to sort fields according to my own choice

EXMPL:  A

              K  

              Y 

             W

             S     

thes  are the fields and i want to sort them like this

            S

            A

           W

            K

            Y   

I dont want to sort them according to character or number,how can i achieve my goal to sort the fields

[#2]

You can create a new filed with the sort order number and use that field for setting the sorting. Look at the example below.

Data2a:
LOAD * Inline [
  myField1
  A
  K
  Y
  W
  S
];

Data2b:
LOAD * Inline [
  myField1, mySortOrder
  A,2
  K,4
  Y,5
  W,3
  S,1
]

[MayilVahanan]

Hi

You can use dual() function in script level.

Or

Match(FieldName,'S','A','W','K','Y') function in Sort tab -> expression

[neetu_singh · Accepted solution]

Hi Kumar,

You can sort the fileds according to your choice by using Mapping Load in your script.

As mention in attached document, you can view the sorting filed into Sheet 1 Tab.

Thanks

Neetu