Search

 

Module: Editor

Version: 2.2.1 +

Type: Long, Double, Date or String

Category: Table

 

Description

The formula 'Sort', sorts the values of a table. Also with the formula 'Sort' it can be specified whether duplicates or empty values have to be removed. The index column has to be specified.

Parameters

Table:                           the table you want to sort.

Column:                        the column index for the sort operation.

Remove_duplicate:        specifies whether duplicates must be removed (True) or not (False).

Remove_empty_rows:    specifies whether empty values must be removed (True) or not (False).

Example

Description

In the following example the formula 'Sort' is used to sort a table.

Values parameters

Matrix:

Column 1
 7
 -2
 6
 12
 7
 0

Column:                        0

Remove_duplicate:        True

Remove_empty_rows:    False

 

Result

Output:

Column 1
 -2
 0
 6
 7
 12
 
The second column was used as index for the sorting proces and the value 7 was a duplicate so one of the two was removed.
 
 

Feedback

If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.

Updated: 2014-09-23