Repeat
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.
Click + Tool on the toolbar.
Click See all tools.
Type or search for the Repeat tool. Click Add tool.
In the search bar, search for Repeat. Click Add tool.
Tip
You can also find the Repeat tool in the Clean section.
Connect the pipe to your data set.
In the configuration pane, enter the following information:
Table 48. Repeat tool configurationField
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.