About this task
This example uses a dataset with typical customer information, such as their names, email, company they work in, or their subscription date.
- Select a column containing data that you want to filter, Email for example.
In the profiling area, click the Pattern tab.
The different patterns used in this column are displayed in the form of a chart. Because this column uses
textdata, the chart shows the repartition of the data using word-based patterns.
Switch to the character-based view by clicking the A
This can give you another point of view to analyze your data.
- Switch back to the word-based view by clicking the Text icon.
Click the top bar to apply a filter on the most common pattern.
The preparation now only displays the rows with the
You can also use Ctrl + Click or Shift + Click to select multiple values at the same time and apply a more complex filter.
While pressing the
click the bar corresponding to the
[word][number]@[word].[word]pattern to add this filter to the previous one.The grid now only displays the data corresponding to those two filters.
- In the Functions panel, click a function to execute it on the data you filtered, Delete these Filtered Rows for example.
- In the filter bar, click the cross in each individual filter or click the garbage bin icon to clear the filters and display the whole dataset again.