Module: Editor
Version: 2.2.1 +
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: 0
Remove_duplicate: True
Remove_empty_rows: False
Result
Output:
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.