5.5.2. Sort (High-Speed clip0090  action)

<< Click to Display Table of Contents >>

Navigation:  5. Detailed description of the Actions > 5.5. Standard >

5.5.2. Sort (High-Speed clip0090  action)

 

Icon: clip0122

 

Property window:

 

clip0123

 

clip0124

 

Short description:

Sorts the input table

 

Long Description:

 
Sorts the table and modifies the meta-data of the table to reflect that the table is now sorted in specific way. The “Sort task” can be:

 

a)Really Sort data                                (This modifies the meta-data)
 

b)Only check sort (with errors)                (This modifies the meta-data)
 

c)Only check sort (with warning)                (This does NOT modify the meta-data)
 

Thus, using the “Only check sort (with errors)”, you can modify the meta-data of the table without actually sorting the table (which is usually quite a big job to do).

 

 
Let’s give a small example! Let’s assume that we want to simply sort a CSV file. We want to sort the CSV file on the column ‘revenue” in increasing numerical order. We will have the following Anatella-Graph:

 

clip0125
 

 

Let’s configure the properties of the Sort Action. Click on the ANATEL~3_img303 button. The following standard “Column Chooser” window opens (see section 5.1.4. about the “Column Chooser” window):

 

ANATEL~3_img304

 

Click on the clip0126 button. We obtain the following list of columns:

 

clip0127

 

 

Double-Click on the “wage per hour” column name: you obtain:

 

ANATEL~3_img307

 

 

Click on the clip0128 button: the “Column Chooser” window closes. You can now choose the type of sort that you want: we will select “Numerical order increasing (0..9)”:

 

clip0129

 

As you can see, Anatella currently offers you height “Sort types”:
 

1)Alphabetical order (A..Za..z)

2)Inverse Alphabetical order (z..aZ..A)

3)Alphabetical order - case insensitive(Aa..Zz)

4)Inverse Alphabetical order - case insensitive(Zz..Aa)

5)Numerical order increasing (0..9)

6)Numerical order decreasing (9..0)

7)Date (chronological order)

8)Date (inverse chronological order)

 

More “Sort types” will be added shortly.

 

When you use the “Date” sort types, you must specify a “date format” here: number1  See section 5.1.3. for more information about “date formats”.