How to use the Filter Block
How to use the Filter Block – tutorial transcript
To clean data using the Filter Block:
Step 1. Drag and drop a Filter Block from the Block Library onto the Main Canvas.
Step 2. Connect input data.
Step 3. Define a filter rule that results in either True or False.
Filter Block passes rows that result in TRUE to the “Pass” stub. Rows that result in FALSE are added to the “Reject” stub. If an error occurs, rows are passed to the “Error” stub.
Step 4. Click on the output stub of the block and use Data Viewer to view the results.
- Filter rules
- Block output
You can download a free trial of Analytics Canvas to follow along with the video.