Clean data using a Expression Row Filter node

Step 1: Click on the "Expression Row Filter" node to open the configuration window.

Step 2: Enter the expression below to remove "outliers" or unwanted data.
$["Score"] <= 200

Step 3: Click "Apply and Execute". This keeps only the rows that meet your specified criteria.

Sort results

Step 1: Click on the "Sorter" node to open configuration window.

Step 2: Define one or multiple sorting criteria. In the column dropdown, select your newly created column ("Score_Normalized").

Step 3: Choose the Descending sort order and click "Apply and Execute".

Your data is now cleaned, transformed, and ranked!

Workflow complete!

Keep the momentum going by exploring Just KNIME It! on the Hub to challenge yourself and see how these nodes can be integrated into more complex workflows and use cases.

Transform Data: Remove Duplicates and Outliers

This workflow demonstrates how to prepare raw data for analysis by removing recurring information, filtering out unwanted values, and calculating new metrics to sort our results effectively.