Remove empty
Remove rows of empty data in the columns you specify.
Remove rows that contain empty data in the columns you specify.
Input
The Remove Empty tool requires one data input.
Configuration
Use the following configuration options to configure the Remove Empty tool.
Go to the Pipes module from the side navigation bar.
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.
In the Pipe builder, add at least one data source to your pipe. For more information on adding a data source, see the Data tool.
Click
+ Tool.The Tools modal opens where you can add tools, such as the Aggregate tool to your pipe.
In the Tools modal, search for Remove Empty and then click + Add tool.
Tip
You can also find the Aggregate tool in the Calculate section.
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.
In the configuration pane, go to the Target columns drop-down field, and select any of the following options:
Always use all columns
Select all columns.
Select none of the columns.
Select specific columns from the dataset.
The tool removes empty fields from the columns that you select.