Data Cleaning - Filter Data

Filter data from your Data Cleaning Project by navigating to Run. Then select the Filters button. 

1. Use the filter group section to apply a filter by attribute, operation, and value. 
2. Select the + icon to create another filter criteria within the same group. 
3. Remove filter criteria by selecting the trash icon. 
4. Adjust the operator from AND to OR and vice versa. 

1. Group filter criteria by filter groups. Add filter groups by selecting the 'Add Filter Group' button. 
2. Adjust the operator between filter groups by selecting 'And' or 'Or'.
3. Select 'Remove All' to remove all filter criteria. 
4. Click 'Cancel' to disregard changes. 
5. Select 'Update Filter' to update your filter. 

Results 

1. Displays how many records match your filter
2. Click into the section to add or remove additional fields. 
3. Sort columns in the Results table by clicking on the column header. Rearrange columns by dragging and dropping them across the table. 
4. Scroll down to adjust the number of items displayed per page. By default, the table will display 10 items per page. Select the arrow icon to go to the next page. Click the forward/ backward icon to jump to the last/ first page. 

Run Setup 

Once a filter has been applied, it will appear in the Run Setup page. The number of records will adjust depending on the filter you've applied.