Skip to main content

Varicent ELT Assistant

Limit

Abstract

Limit the number of rows in your data.

Use the Limit tool to limit the number of rows in your data when you want to work with a subset of your data. Starting from the first row in your data, the tool keeps the number of rows you specify.

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.

Input

The Limit tool requires one data input.

Configuration

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

  1. Go to the Pipes module from the side navigation bar.

  2. From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.

  3. In the Pipe builder, add a data source to your pipe. For more information on adding a data source, see the Data Input tool.Data Input

  4. Click symon_add_icon.png + Tool.

    The Tools modal opens, where you can add tools, such as the  Aggregate  tool, to your pipe.

  5. In the Tools modal search bar, type Limit, and then click + Add tool.

    Tip

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

  6. Click the tool node and drag the line to the next tool to connect the tools. If you need to undo the action, click the line and then click Unlink.

  7. In the configuration pane, enter the number of rows to limit the number of data to work with.