Categorizes values in a column according to a dictionary table with min/max values. The table at the first input contains a column with values to be categorized. The second table contains a column with lower bound values, a column with upper bound values and a column with label values. The latter will be used as outcome in case a given value is between the corresponding lower and upper bound. Each row in the second table represents a rule, whereby the rules are evaluated top-down, i.e. rules with low row index have higher priority than rules in the subsequent rows.
Either the lower or upper bound test can be disabled by unsetting the corresponding checkbox in the dialog. Missing values in the columns containing upper and lower bounds will always evaluate the bound check to true. That is, a missing value in the lower bound column will always be smaller and a missing value in the upper bound column will always be larger than the value. Missing values in the value column (1st input) will result in a missing cell output (no categorization).
Note: The table containing bound and label information (2nd input) will be read into memory during execution; it must be a relatively small table!
Options
Popular Predecessors
Excel Reader (XLS)21 %- Table Creator3 %
String To Number3 %- GroupBy2 %
- Excel Reader2 %
Excel Reader (XLS)2 %- Column Auto Type Cast2 %
Joiner2 %- Date&Time Difference2 %
- Scorer1 %
- Binner (Dictionary)1 %
- Math Formula1 %
- File Reader1 %
Table Reader1 %Row Filter (deprecated)1 %- Column Resorter1 %
- Column Combiner< 1 %
File Reader< 1 %- Auto-Binner (Apply)< 1 %
Number To String< 1 %- Joiner< 1 %
- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Pivot< 1 %
- CSV Reader< 1 %
- Concatenate< 1 %
- Table Transposer< 1 %
- Value Counter< 1 %
- Color Manager< 1 %
Cell Replacer< 1 %- String to Date&Time< 1 %
- Category to Number< 1 %
Column Appender< 1 %- Column Renamer (Dictionary)< 1 %
- Column Rename (Regex)< 1 %
- Double to Integer< 1 %
- Reference Row Filter< 1 %
- Normalizer< 1 %
Column Rename< 1 %String Replace (Dictionary)< 1 %- Rule-based Row Filter< 1 %
- Rule Engine< 1 %
- Number to String< 1 %
- Rule Engine (Dictionary)< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Statistics< 1 %
- Date&Time Shift< 1 %
- Unpivot< 1 %
CSV Reader< 1 %Database Reader< 1 %- Group Loop Start< 1 %
- Constant Value Column< 1 %
- Column Filter< 1 %
Row Splitter (deprecated)< 1 %- Missing Value< 1 %
- Number Rounder< 1 %
- RowID< 1 %
- Sorter< 1 %
- String Manipulation< 1 %
- Counter Generation< 1 %
- Math Formula (Multi Column)< 1 %
- String to Date/Time (legacy)< 1 %
- Chunk Loop Start< 1 %
- Cell Splitter< 1 %
- String to Number< 1 %
- Lag Column< 1 %
- Create Table Structure< 1 %
- Duplicate Row Filter< 1 %
- String Replacer< 1 %
Merge Variables< 1 %- Column Expressions (legacy)< 1 %
Excel Reader (XLS)< 1 %- Nominal Value Row Filter< 1 %
- Table Manipulator< 1 %
- Date&Time to legacy Date&Time< 1 %
- Date&Time Part Extractor< 1 %
Variable to Table Row< 1 %Database Connection Table Reader< 1 %- Box Plot (legacy)< 1 %
- Parallel Chunk End< 1 %
XLS Reader< 1 %- Column Filter (legacy)< 1 %
- Time Difference (legacy)< 1 %
- Text Classifier Model to Table< 1 %
- CAIM Applier< 1 %
- Dictionary Tagger< 1 %
- Value Filter (legacy)< 1 %
- One to Many< 1 %
- Missing Value Column Filter< 1 %
- Parallel Chunk Start< 1 %
- Java Snippet Row Filter< 1 %
- Add Empty Rows< 1 %
- Column Aggregator< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Number to String (PMML)< 1 %
- Rank< 1 %
- DB Query Reader< 1 %
Read Excel Sheet Names (XLS)< 1 %- Loop End (Column Append)< 1 %
- Moving Average< 1 %
Table Row To Variable Loop Start< 1 %- k-Means< 1 %
- Reference Column Filter< 1 %
- Reference Row Splitter< 1 %
- Rule-based Row Splitter< 1 %
- Extract Table Dimension< 1 %
- Date Field Extractor (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Split Collection Column< 1 %
Recursive Loop Start (2 ports)< 1 %Linear Correlation< 1 %- String Splitter (Regex)< 1 %
- Numeric Row Splitter< 1 %
- Rank Correlation< 1 %
- Numeric Outliers< 1 %
- End IF< 1 %
- IF Switch< 1 %
Python Script (1⇒1)< 1 %- Date&Time to String< 1 %
- Loop End< 1 %
- Column Appender< 1 %
- Numeric Binner (PMML)< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Modify Time< 1 %
- RDKit Substructure Counter< 1 %
- Strings to Binary Objects< 1 %
- Java Snippet< 1 %
Loop End< 1 %- Hierarchical Clustering< 1 %
Regression Predictor< 1 %- Column Name Extractor< 1 %
- Cross Joiner< 1 %
- CAIM Binner< 1 %
- Row Sampling< 1 %
- Column Splitter< 1 %
- Ungroup< 1 %
- Ruleset Editor< 1 %
- Empty Table Switch< 1 %
- Empty Table Creator< 1 %
Strings To Document< 1 %Python Script (1⇒1)< 1 %- Create Date&Time Range< 1 %
- Time Generator (legacy)< 1 %
- Canonical SMILES< 1 %
- Create Collection Column< 1 %
- List MIME-Types< 1 %
Line Reader< 1 %Counting Loop Start< 1 %- Column List Loop Start< 1 %
Generic Loop Start< 1 %- X-Aggregator< 1 %
- Cluster Assigner< 1 %
- Fuzzy c-Means< 1 %
Scorer< 1 %Concatenate (Optional in)< 1 %- Case Converter< 1 %
Cell Splitter< 1 %- Cell Splitter By Position< 1 %
- Category to Number (Apply)< 1 %
- Column Merger< 1 %
- Many to One< 1 %
- Correlation Filter< 1 %
- Domain Calculator< 1 %
- Interactive HiLite Collector< 1 %
- Nominal Value Row Splitter< 1 %
- Normalizer (PMML)< 1 %
Number To String (PMML)< 1 %String To Number (PMML)< 1 %- Shuffle< 1 %
- Rule Engine Variable (Dictionary)< 1 %
- Numeric Outliers (Apply)< 1 %
- Cache< 1 %
- DB Reader< 1 %
- Random Number Assigner< 1 %
- Random Number Assigner (Apache)< 1 %
PMML Predictor< 1 %- Item Set Finder (Borgelt)< 1 %
- Java Edit Variable (simple)< 1 %
- TF< 1 %
- String Matcher< 1 %
- Number Filter< 1 %
Column Selection Configuration< 1 %- Integer Input (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Integer Widget< 1 %
- R Source (Table)< 1 %
- R Snippet< 1 %
- GET Request< 1 %
- Duration to Number< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Moving Aggregator< 1 %
- Time to String (legacy)< 1 %
- Fast Fourier Transform (FFT)< 1 %
- Table Reader< 1 %
- PNN Learner (DDA)< 1 %
- Logistic Regression Learner< 1 %
- Constant Value Column Filter< 1 %
- String Manipulation (Multi Column)< 1 %
- Ruleset to Table< 1 %
- Conditional Box Plot (legacy)< 1 %
- Java Snippet (simple)< 1 %
- Dictionary Filter< 1 %
- List Files/Folders< 1 %
- Table Editor (JavaScript)< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Date Extractor< 1 %
Views
- This node has no views
Workflows
01_Static_geolocation_of_IP_addressesKNIME Hub- 01_Static_geolocation_of_IP_addressesKNIME Hub
- 01_Static_geolocation_of_IP_addressesKNIME Hub
- 02_Dynamic_geolocation_of_IP_addressesKNIME Hub
- 03_GeoIP_Visualization_using_Open_Street_Map_(OSM)KNIME Hub
- Show all 29 workflows
Links
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.