Creating a filter transformation

Filtering out data using filters, or deleting marked rows, might sometimes not be permanent enough to remove unwanted data from your analysis, because reloading the data or resetting the filters might bring the undesired data back. If you want to make sure that values gets permanently removed, you can instead add a filter transformation.

About this task

A quick and easy way to create such a transformation is by filtering out the undesired data and creating a transformation based on the currently filtered rows.

Before you begin

You must have some data loaded in the analysis, and the analysis must be in Editing mode.

Procedure

In the Filters panel, or in the Data in analysis flyout, filter your data to include only what you want to keep in the analysis.
When you are done, right-click the filter and select Create filter transformation from the pop-up menu.
In the Filters panel, you can press Ctrl and select more than one filter before right-clicking, if you want to base the transformation on more than one filter.

A transformation is added to the data table, where the filtered out data is excluded. You can remove the Filter rows transformation from the Data canvas at any time, or review the expression used on the Information tab. In the installed client, you can also edit the expression behind the transformation from the Data canvas.

Results

The added transformation will exclude rows based on a boolean expression which is created from all the modified filters in the selection. Only those rows matching the expression (the rows for which the expression is True) will be included in the data table.