Skip to main content

Varicent ELT Help Center

Repeat

Abstract

Replicate every row in your data set many times.

Replicate every row in your data set any number of times.

When to use this tool

Use when you want to repeat rows in your data set.

Input

The Repeat tool requires one data input.

Configuration

Use the following configuration options to help replicate your data.

Configuring the Repeat tool

  1. Click add_to_dashboard.png + Tool on the toolbar.

  2. In the search bar, type Repeat. Click + Add tool.

    Tip

    You can also find the Repeat tool in the Clean section.

  3. Connect the tool to your data set.

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

    Table 51. Repeat tool configuration

    Field

    Description

    Repetition frequency

    Enter the number of repetitions or click the up or down arrows until you get the desired number.

    Caution

    If your output data set includes more than 10 million rows, this could impact performance.

    Enable repetition count

    Enable to turn on the identification of the number of repetitions per row.

    Note

    By enabling the count, it adds a repetition count column.

    Repetition column name

    Enter a column name for the number of repetitions.



Use case

Use the Repeat tool to repeat your data a specified number of times. This repeated data can be used to test different logic and and choose the most effective approach. Combine the Repeat tool with the Random number generator tool to support forecasting through simulations.

For example, use the Repeat tool to repeat the dataset 100 times. Then, add the Random number generator tool to the pipe. The Random number generator tool will generate 100 simulations based on these repeats, which can be used to forecast different outcomes. You will need to specify the original dataset in the Random number generator tool, so it can partition by the repeat ID and learn the distribution from the original data.