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 rows transformation.
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.
To create a transformation based on current filter settings:
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.
Comment: 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.
Response: A transformation is added to the data table where the filtered out data is excluded. You can review and edit the transformation from the Data canvas at any time.
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.