Scans the data and updates the possible values list and/or the min- and max values of selected columns. This node is useful when the domain information of the data has changed and must be updated in the table specification, for instance, the domain information as contained in a table spec may be void when a row filtering (e.g. outlier removal) is carried out.
Options
Popular Predecessors
Row Filter (deprecated)4 %- Nominal Value Row Filter3 %
String To Number3 %- Column Filter2 %
- Number to String2 %
- CSV Reader2 %
- Concatenate2 %
- Excel Reader2 %
- String Manipulation2 %
- Joiner2 %
Joiner2 %- Missing Value2 %
Column Appender2 %- Date&Time-based Row Filter1 %
- GroupBy1 %
- Sorter1 %
Concatenate (Optional in)1 %- Rule-based Row Filter1 %
Number To String (PMML)< 1 %XLS Reader< 1 %- Duplicate Row Filter< 1 %
- Partitioning< 1 %
File Reader< 1 %Scorer< 1 %- Normalizer< 1 %
- R Snippet< 1 %
- Numeric Outliers< 1 %
- Column Expressions< 1 %
Loop End< 1 %- Rule Engine< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Math Formula< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Row Filter (Labs)< 1 %
- Counter Generation< 1 %
- Binary Classification Inspector< 1 %
- Case Converter< 1 %
- One to Many< 1 %
Column Rename< 1 %Excel Reader (XLS)< 1 %- Table Creator< 1 %
- Correlation Filter< 1 %
- Numeric Row Splitter< 1 %
Random Forest Learner< 1 %- Column Aggregator< 1 %
Row Splitter (deprecated)< 1 %- Row Sampling< 1 %
- Empty Table Switch< 1 %
- Parquet Reader< 1 %
Database Reader< 1 %PCA< 1 %- Number Rounder< 1 %
- Cell Splitter< 1 %
- DB Reader< 1 %
- DB Query Reader< 1 %
- String to Path< 1 %
- Java Snippet< 1 %
Generic Loop Start< 1 %- DBSCAN< 1 %
- Numeric Binner< 1 %
- Column Name Extractor< 1 %
- HiLite Row Splitter< 1 %
- Table Transposer< 1 %
- String to Number< 1 %
- Capture Workflow Start< 1 %
- Scorer< 1 %
- Column Filter Configuration< 1 %
- Nominal Row Filter Widget< 1 %
- MolImporter< 1 %
CSV Reader< 1 %- Auto-Binner< 1 %
Cell Splitter< 1 %- Column Resorter< 1 %
- Missing Value (Apply)< 1 %
- Data Generator< 1 %
Excel Reader (XLS)< 1 %- UNIX Timestamp to Date&Time< 1 %
- String Manipulation (Multi Column)< 1 %
- R Source (Table)< 1 %
- Date&Time Difference< 1 %
- Range Filter< 1 %
- k-Means< 1 %
- Linear Regression Learner< 1 %
Cell Replacer< 1 %- Column Combiner< 1 %
- Category to Number< 1 %
- Number to Category (Apply)< 1 %
- Column Merger< 1 %
- Column Rename (Regex)< 1 %
- Domain Calculator< 1 %
- Edit Numeric Domain< 1 %
- Reference Row Filter< 1 %
- Reference Row Splitter< 1 %
- Low Variance Filter< 1 %
- Normalizer (Apply)< 1 %
- Denormalizer< 1 %
- Normalizer (PMML)< 1 %
- RowID< 1 %
- String Replacer< 1 %
- Ungroup< 1 %
- Cache< 1 %
- Color Manager< 1 %
- Frequency Filter< 1 %
- Inject Variables (Data)< 1 %
String To Number (PMML)< 1 %- String Manipulation (Variable)< 1 %
- Top k Row Filter< 1 %
- Crosstab< 1 %
- Nominal Row Filter Configuration< 1 %
- Lift Chart (JavaScript)< 1 %
- Interactive Value Filter Widget< 1 %
- Fingerprints Expander< 1 %
- File Reader< 1 %
- Loop End< 1 %
- List Files/Folders< 1 %
- Path to String< 1 %
- Column Filter Widget< 1 %
- Refresh Button Widget< 1 %
- Python Script (legacy)< 1 %
- Anonymization< 1 %
- Table Validator (Reference)< 1 %
- Counting Loop Start< 1 %
Table Column to Variable< 1 %List Files< 1 %- Column List Loop Start< 1 %
- Group Loop Start< 1 %
- X-Partitioner< 1 %
- Logistic Regression Learner< 1 %
Regression Predictor< 1 %- SMOTE< 1 %
- Random Forest Learner< 1 %
- Auto-Binner (Apply)< 1 %
- Binner (Dictionary)< 1 %
- Column Auto Type Cast< 1 %
- Column Comparator< 1 %
- Constant Value Column< 1 %
- Cross Joiner< 1 %
- Edit Nominal Domain< 1 %
- Equal Size Sampling< 1 %
- Reference Column Filter< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Splitter< 1 %
- Pivot< 1 %
- Shuffle< 1 %
- Column Splitter< 1 %
- Value Counter< 1 %
- Rule-based Row Splitter< 1 %
- Data Explorer< 1 %
- Statistics< 1 %
- Box Plot (legacy)< 1 %
- Parallel Chunk End< 1 %
- Math Formula (Multi Column)< 1 %
- Category to Class< 1 %
- Value Filter (legacy)< 1 %
- JSON to Table< 1 %
- String to Date&Time< 1 %
- Date Field Extractor (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- RDKit Descriptor Calculation< 1 %
- Create Collection Column< 1 %
- Strings to Binary Objects< 1 %
- URL to File Path< 1 %
- Decision Tree Predictor< 1 %
- PCA< 1 %
- Constant Value Column Filter< 1 %
- Number to String (PMML)< 1 %
- Unpivot< 1 %
- IF Switch< 1 %
Python Script (1⇒2)< 1 %- Date&Time to String< 1 %
- Modify Time< 1 %
- Molecular Properties< 1 %
- Table Row to Variable< 1 %
- CSV Writer< 1 %
- Table Reader< 1 %
- Column Appender< 1 %
- Table Manipulator< 1 %
- One to Many (PMML)< 1 %
- CASE Switch Start< 1 %
- k-Medoids< 1 %
- Bag Of Words Creator< 1 %
- Line Plot (JavaScript)< 1 %
- Date&Time Part Extractor< 1 %
- Value Lookup< 1 %
- Regex Extractor< 1 %
- Column Renamer< 1 %
Table Reader< 1 %Random Forest Predictor< 1 %- Table Validator< 1 %
- Double to Integer< 1 %
- End IF< 1 %
- Time to String (legacy)< 1 %
- Normalize Plates (POC)< 1 %
- Lift Chart (legacy)< 1 %
- Scorer (JavaScript)< 1 %
- Moving Average< 1 %
- Outlier Removal< 1 %
PCA Apply< 1 %- Extract Table Dimension< 1 %
- ROC Curve (legacy)< 1 %
- Spark to Table< 1 %
- H2O to Table< 1 %
- R Predictor< 1 %
- Create Well Position< 1 %
- Catch Errors (Data Ports)< 1 %
- Add Empty Rows< 1 %
Double To Int< 1 %- Filter Apply< 1 %
- Math Formula (Variable)< 1 %
- Index Query< 1 %
- StanfordNLP Relation Extractor< 1 %
- Sentence Extractor< 1 %
- Column Filter (legacy)< 1 %
- Table View (JavaScript)< 1 %
- XML to JSON< 1 %
Python Script (2⇒1)< 1 %- Extract Duration Fields< 1 %
- Variable to Table Column< 1 %
- Model Reader< 1 %
- CASE Switch End< 1 %
- Column Selection Widget< 1 %
- Normalize Plates (Z-Score)< 1 %
- Convert to Table< 1 %
- Cluster Assigner< 1 %
- Distance Matrix Pair Extractor< 1 %
Number To String< 1 %- Edit Nominal Domain (Dictionary)< 1 %
String Replace (Dictionary)< 1 %- Shape Manager< 1 %
- Java Snippet (simple)< 1 %
- Java Snippet Row Filter< 1 %
- Java Snippet Row Splitter< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Term to String< 1 %
- Date&Time to legacy Date&Time< 1 %
- Mask Date/Time (legacy)< 1 %
- Wait...< 1 %
- ARFF Reader< 1 %
Variable Condition Loop End< 1 %- MultiLayerPerceptron Predictor< 1 %
Random Forest Learner< 1 %- CAIM Binner< 1 %
- Filter Apply Row Splitter< 1 %
- SDF Reader< 1 %
- TF< 1 %
- Integer Configuration< 1 %
- Value Filter Definition (legacy)< 1 %
- Text Output Widget (legacy)< 1 %
- Image Generator< 1 %
- Disturber Node< 1 %
- Time Difference (legacy)< 1 %
- Country Extractor< 1 %
IF Switch (Flow Variable Value)< 1 %- Active Branch Inverter< 1 %
Variable to Table Column< 1 %- Table Column to Variable< 1 %
Recursive Loop End< 1 %- Numeric Scorer< 1 %
- Parameterized DB Query Reader< 1 %
- Read Excel Sheet Names< 1 %
- Weka Cluster Assigner (3.6) (legacy)< 1 %
- Parameter Optimization Loop End< 1 %
- Parameter Optimization Loop Start (Table)< 1 %
- Plate Row Converter< 1 %
- Z-Primes (PC x NC)< 1 %
- Plate Heatmap Viewer< 1 %
- Matlab Snippet< 1 %
- Split Collection Column< 1 %
- URI to String< 1 %
Database Connection Table Reader< 1 %- Loop End (Column Append)< 1 %
Counting Loop Start< 1 %- Chunk Loop Start< 1 %
Recursive Loop Start< 1 %- PNN Learner (DDA)< 1 %
- Hierarchical Clustering< 1 %
Gradient Boosted Trees Predictor< 1 %- Create Bit Vector< 1 %
- Rank< 1 %
- Time Series Generator< 1 %
- Geo-Coordinate Row Filter< 1 %
Excel Reader (XLS)< 1 %- Java Edit Variable (simple)< 1 %
- Parameter Optimization Loop Start< 1 %
Extract Date&Time Fields< 1 %Loop End (3 ports)< 1 %- Run Garbage Collector< 1 %
- Collection to String< 1 %
- Join Layout< 1 %
- Vector Length Normalization< 1 %
- ARIMA Predictor< 1 %
- String to URI< 1 %
- Try (Data Ports)< 1 %
Variable to Table Column< 1 %Variable to Table Row< 1 %- Java Edit Variable< 1 %
- Fuzzy Rule Learner< 1 %
- Fuzzy c-Means< 1 %
K Nearest Neighbor< 1 %- K Nearest Neighbor< 1 %
- MDS (DistMatrix)< 1 %
- OPTICS Cluster Assigner< 1 %
Logistic Regression Learner< 1 %- Regression Predictor< 1 %
Numeric Scorer< 1 %- Gradient Boosted Trees Predictor (Regression)< 1 %
- Tree Ensemble Learner< 1 %
- Random Forest Learner (Regression)< 1 %
- Random Forest Predictor< 1 %
- Bootstrap Sampling< 1 %
- Category to Number (Apply)< 1 %
- Column Renamer (Dictionary)< 1 %
- Lag Column< 1 %
- Column to Grid< 1 %
- Many to One< 1 %
- Create Table Structure< 1 %
- Interactive HiLite Collector< 1 %
- Numeric Binner (PMML)< 1 %
- Normalizer Apply (PMML)< 1 %
- Reference Column Resorter< 1 %
- Set Operator< 1 %
- Target Shuffling< 1 %
- Renderer to Image< 1 %
- Rule Engine Variable< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- One-way ANOVA< 1 %
CASE Switch Data (Start)< 1 %- Conditional Box Plot (legacy)< 1 %
- HiLite Table (legacy)< 1 %
- Size Manager< 1 %
- PMML Transformation Apply< 1 %
- Fingerprint Bayesian Predictor< 1 %
- TimeDelay Loop Start< 1 %
- Model Loop Start< 1 %
- SAS7BDAT Reader< 1 %
Read Excel Sheet Names (XLS)< 1 %- Java IF (Table)< 1 %
- Spark Line Appender< 1 %
- Case Converter< 1 %
- Dictionary Replacer< 1 %
Document vector< 1 %- Document Vector< 1 %
- Tags to String< 1 %
- Term Vector< 1 %
- String Configuration< 1 %
- Date&Time Input (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Scatter Plot (JavaScript)< 1 %
- String Widget< 1 %
- Container Input (Table)< 1 %
- Table to JSON< 1 %
- JSON Path< 1 %
- Image Normalizer< 1 %
- Labeling Converter< 1 %
- Network Analyzer< 1 %
Python Script (1⇒1)< 1 %- Python Source (legacy)< 1 %
Value Filter QuickForm (legacy)< 1 %- Test Data Generator< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Create Date&Time Range< 1 %
- Date&Time Shift< 1 %
- Date/Time Shift (legacy)< 1 %
- Moving Aggregator< 1 %
XML Reader< 1 %- Mass Calculator< 1 %
- RDKit From Molecule< 1 %
- RDKit Find Murcko Scaffolds< 1 %
- RDKit Substructure Counter< 1 %
- Coordinate to Latitude/Longitude< 1 %
- Latitude/Longitude to Coordinate< 1 %
- AP Calculator< 1 %
- File Reader (Complex Format)< 1 %
- Line Reader< 1 %
- PMML Writer< 1 %
- Association Rule Learner< 1 %
- SVM Predictor< 1 %
- PCA Apply< 1 %
- Expand Bit Vector< 1 %
- Cell Splitter By Position< 1 %
- Column Filter (PMML)< 1 %
- String Splitter (Regex)< 1 %
- Decision Tree to Ruleset< 1 %
- Workflow Executor< 1 %
- Parallel Chunk Start< 1 %
- Boosting Predictor Loop Start< 1 %
- Excel Writer< 1 %
- t-SNE (L. Jonsson)< 1 %
- Decompress Files< 1 %
- Boolean Configuration< 1 %
- Table Editor (JavaScript)< 1 %
- Single Selection Widget< 1 %
- Container Input (Row)< 1 %
- R to Table< 1 %
- Create Hierarchy< 1 %
- BERT Predictor< 1 %
- URL Domain Extractor< 1 %
Views
- This node has no views
Workflows
_01_Network_Traffic_ReportingKNIME Hub- !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
- 0_install_AI_extensionsKNIME Hub
- 00 Data GenerationKNIME Hub
- 00_DataApp_Visual_Analysis_of_Sales_DataKNIME Hub
- Show all 958 workflows
Links
- Legacy Range from Filtered Columnby HansS on 2020-02-28forum.knime.com/p/82962
- Unused string values after joinerby AnotherFraudUser on 2020-05-25forum.knime.com/p/92311
- How to calculate nominal domain for more than 60 unique valuesby izaychik63 on 2020-04-25forum.knime.com/p/88935
- Table Difference Checker node failing execution despite equal input tablesby qqilihq on 2018-08-30forum.knime.com/p/47139
- How to randomly pick a string from existing table?by kowisoft on 2019-07-03forum.knime.com/p/64339
- Show all 19 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.