Version: 2.2.1 +
Type: Long, Double, Date or String
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.
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).
In the following example the formula 'Sort' is used to sort a table.
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.
If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.