Skip to main content

Varicent ELT Help Center

Sample

Abstract

Randomly select a smaller number of rows from your data.

Randomly select a smaller number of rows from your data.

When to use this tool

Use when you want to work with a smaller sample 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 Sample tool.

Configuring the Sample 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 Sample.

    Tip

    You can also find the Sample 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 60. Sample tool configuration

    Field

    Description

    Fraction

    Enter a number or use the arrows to increase or decrease the value.