Data connectivity & integrationPipeline Builder TransformsSort

Sort

Supported in: Batch, Faster

Transforms input dataset either by selecting columns or applying functions to columns.

Transform categories: Other

Declared arguments

  • Dataset: Dataset to sort.
    Table
  • Sort specification: Specification for how to sort the dataset.
    List<Tuple<Expression<ComparableType>, Enum<Ascending, Descending>>>

Examples

Example 1: Base case

Argument values:

  • Dataset: ri.foundry.main.dataset.a
  • Sort specification: [(b, DESCENDING)]

Input:

ab
12
34
56

Output:

ab
56
34
12

Example 2: Base case

Description: Sorts by the absolute value of a column.

Argument values:

  • Dataset: ri.foundry.main.dataset.a
  • Sort specification: [(
    abs(
     expression: b,
    ), DESCENDING)]

Input:

ab
34
5-2
1-6

Output:

ab
1-6
34
5-2