Creating a Filter
You can create a filter so that you can make a subset of the original data source that meets the filter criteria. You can then run a profile on this sample data.
1. Open a profile.
2. Click Actions > Edit > Column Profiling Filters to open the Edit Profile dialog box.
The current filters appear in the Filters panel.
3. Click New.
4. Enter a filter name and an optional description.
5. Select a simple, advanced, or SQL filter type.
- - Simple. Use conditional operators, such as <, >, =, BETWEEN, and ISNULL for each column that you want to filter.
- - Advanced. Use function categories, such as Character, Consolidation, Conversion, Financial, Numerical, and Data cleansing.
Click the function name on the Functions panel to view its return type, description, and parameters. To include the function in the filter, click the right arrow (>) button, and you can specify the parameters in the Function dialog box.
Note: For a simple or an advanced filter on a date column, provide the condition in the YYYY/MM/DD HH:MM:SS format.
- - SQL. Creates SQL queries. You can create an SQL filter for relational data sources. Enter the WHERE clause expression to generate the SQL filter. For example, to filter company records in the European region from a Company table with a Region column, enter
Region = 'Europe'
in the editor.
6. Click Validate to verify the SQL expression.