Рет қаралды 693
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 Filter Block and use Data Viewer to view the results.