Skip to main content

Varicent ELT Help Center

Sort

Abstract

Sort your data based on the column that you specify.

Sorts data based on the column you specify.

You can sort in ascending or descending order.

When to use this tool

Use when you want to organize your data so you can better understand it.

Figure 8. Sort tool example
Sort tool example


Input

The Sort tool requires one data input.

Configuration

Use the following configuration options to help create your Sort configuration.

Configuring the Sort tool

  1. In Varicent ELT, go to the Pipes module.

  2. On the Pipes tab, find the pipe you want to work with. Click the pipe to open.

  3. In your pipe, add your data source.

  4. Click symon_add_icon.png +Tool.

  5. In the search bar, search for Sort. Click + Add tool.

    Tip

    You can also find the Sort tool in the Organize section.

  6. Connect the tool to your data set.

  7. In the configuration pane, enter the following information:

    Table 70. Sort tool configuration

    Field

    Description

    Sort criteria

    Sort by

    Select the column that you want to sort.

    Ascending - Descending

    Toggle to switch to sort your data either in ascending or descending order.

    + New sort criteria

    Click to add another sort criteria to your data.