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.
- 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.
A transformation is added to the data table, where the filtered out data is excluded. You can review or remove the transformation from the Data canvas at any time.