Skip to main content

Varicent ELT Help Center

Limit

Abstract

Limit the number of rows in your data.

Limit the number of rows in your data. Starting from the first row in your data, the tool keeps the number of rows you specify.

When to use this tool

Use when you want to work with a sub-set of your data.

Tip

You can configure this tool without using the configuration menu.

In the Add tool menu, start typing the first few letters of the tool name and press tab to auto-complete. Then start typing the name of the column you want to use and press tab to auto-complete.

Configuration

Use the following configuration options to help configure the Limit tool.

Configuring the Limit 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 builder add your data source.

  4. On the canvas toolbar, click symon_add_icon.png + Tool.

  5. In the Tools modal search bar, type Limit.

    Tip

    You can also find the Limit tool in the Data section.

  6. Click + Add Tool

  7. Connect the tool to your data set.

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

    Table 58. Limit configuration table

    Field

    Description

    Limit

    Enter the number of rows to limit the number of data to work with.