Skip to main content

Varicent ELT Assistant

Sample

Use the Sample tool when you want to work with a smaller sample of data. The tool randomly selects a smaller number of rows from 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. 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 Sample, and then click + Add tool.

    Tip

    You can also find the Sample 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, under Fraction, enter a number or use the arrows to increase or decrease the value.