The Data Explorer node offers a range of options for displaying properties of the input data in an interactive view.
The node supports custom CSS styling. You can simply put CSS rules into a single string and set it as a flow variable 'customCSS' in the node configuration dialog. You will find the list of available classes and their description on our documentation page.
Options
Table
Popular Predecessors
- CSV Reader13 %
- Excel Reader6 %
- Column Filter6 %
- Missing Value4 %
Row Filter (deprecated)3 %- Joiner2 %
- File Reader2 %
- Number to String2 %
- GroupBy2 %
- Math Formula2 %
- Normalizer2 %
- Duplicate Row Filter2 %
- Rule Engine1 %
- One to Many1 %
Joiner1 %String To Number< 1 %- Table Reader< 1 %
- Extract Table Spec< 1 %
Loop End< 1 %- Rule-based Row Filter< 1 %
Excel Reader (XLS)< 1 %- Concatenate< 1 %
- String Replacer< 1 %
- Column Auto Type Cast< 1 %
- Numeric Outliers< 1 %
- Statistics< 1 %
- Color Manager< 1 %
- Many to One< 1 %
- Data Explorer< 1 %
- String to Number< 1 %
- Extract Missing Value Cause< 1 %
- Interactive Range Slider Filter Widget< 1 %
Database Update< 1 %File Reader< 1 %- Missing Value Column Filter< 1 %
- Table Editor (JavaScript)< 1 %
Linear Correlation< 1 %- String to Date&Time< 1 %
- Filter Apply< 1 %
- Molecule Type Cast< 1 %
- Nominal Row Filter Widget< 1 %
- Linear Regression Learner< 1 %
- Constant Value Column Filter< 1 %
- Reference Row Filter< 1 %
- SMOTE< 1 %
- Domain Calculator< 1 %
Column Rename< 1 %- Sorter< 1 %
- R Snippet< 1 %
- Java Snippet< 1 %
- PCA< 1 %
- Constant Value Column< 1 %
Row Splitter (deprecated)< 1 %- DB Reader< 1 %
- Table Manipulator< 1 %
- Rank Correlation< 1 %
- CASE Switch Start< 1 %
- Parquet Reader< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Column Expressions< 1 %
- Table View (JavaScript)< 1 %
- Date&Time Difference< 1 %
- Cell Splitter< 1 %
- Column Aggregator< 1 %
- Linear Correlation< 1 %
- Partitioning< 1 %
- String Manipulation (Multi Column)< 1 %
- Crosstab< 1 %
- Interactive Table (legacy)< 1 %
- DB Writer< 1 %
- Bubble Chart (Plotly)< 1 %
- Column Filter (legacy)< 1 %
- Scorer (JavaScript)< 1 %
- File Reader (Complex Format)< 1 %
- Correlation Filter< 1 %
- IF Switch< 1 %
Table Reader< 1 %- Equal Size Sampling< 1 %
- Reference Column Filter< 1 %
- Number Rounder< 1 %
- Row Sampling< 1 %
- Numeric Outliers (Apply)< 1 %
- Line Plot (JavaScript)< 1 %
- k-Means< 1 %
Cell Replacer< 1 %- Number to Category (Apply)< 1 %
- Column Merger< 1 %
- Column Rename (Regex)< 1 %
- Filter Apply Row Splitter< 1 %
- Low Variance Filter< 1 %
- Denormalizer< 1 %
- Missing Value (Apply)< 1 %
- RowID< 1 %
- Spark to Table< 1 %
Python Script (1⇒1)< 1 %- Modify Date< 1 %
- Silhouette Coefficient< 1 %
- Numeric Scorer< 1 %
- Cross Joiner< 1 %
- Row Splitter (Labs)< 1 %
- Normalizer (PMML)< 1 %
- Unpivot< 1 %
- Python Script (legacy)< 1 %
- RDKit Descriptor Calculation< 1 %
- Column Renamer< 1 %
- HiLite Row Splitter< 1 %
- Table Creator< 1 %
- Decision Tree Predictor< 1 %
- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Column Combiner< 1 %
- Category to Number< 1 %
- Column Resorter< 1 %
- Double to Integer< 1 %
- Nominal Value Row Filter< 1 %
- String Manipulation< 1 %
- Table Transposer< 1 %
- Value Counter< 1 %
- Rule-based Row Splitter< 1 %
- Data Generator< 1 %
- Math Formula (Multi Column)< 1 %
- Scatter Plot (JavaScript)< 1 %
- JSON to Table< 1 %
- R to Table< 1 %
- Date&Time-based Row Filter< 1 %
- ARFF Reader< 1 %
- DBSCAN< 1 %
- Regression Predictor< 1 %
- Case Converter< 1 %
- Column Comparator< 1 %
- Nominal Value Row Splitter< 1 %
- Row Filter (Labs)< 1 %
- Pivot< 1 %
- Number to String (PMML)< 1 %
- String to Number (PMML)< 1 %
- Column Splitter< 1 %
- Shape Manager< 1 %
- DB Query Reader< 1 %
- Text Output (legacy)< 1 %
- Date&Time to String< 1 %
- Legacy Date&Time to Date&Time< 1 %
- String to Date/Time (legacy)< 1 %
- Python Snippet< 1 %
- Table Column to Variable< 1 %
- Loop End< 1 %
- X-Aggregator< 1 %
- Cluster Assigner< 1 %
- Logistic Regression Learner< 1 %
- Scorer< 1 %
- Association Rule Learner< 1 %
- Column Appender< 1 %
- Normalizer (Apply)< 1 %
- One to Many (PMML)< 1 %
- Column Filter Configuration< 1 %
- Date&Time Part Extractor< 1 %
Regex Extractor< 1 %- Value Lookup< 1 %
- k-Medoids< 1 %
- Variable Creator< 1 %
- Denormalizer (PMML)< 1 %
- Strings to Document< 1 %
- Parameter Optimization Loop End< 1 %
- Group Loop Start< 1 %
Column Appender< 1 %- Shuffle< 1 %
- SAS7BDAT Reader< 1 %
- Date&Time to legacy Date&Time< 1 %
- Modify Time< 1 %
Database Reader< 1 %- Cell Splitter By Position< 1 %
- Column Renamer (Dictionary)< 1 %
- Box Plot (legacy)< 1 %
- Random Number Assigner< 1 %
- Stacked Area Chart (Plotly)< 1 %
Read Excel Sheet Names (XLS)< 1 %Column Filter Configuration< 1 %- Column Filter Widget< 1 %
- Create Date&Time Range< 1 %
- XPath< 1 %
CSV Writer< 1 %- Edit Numeric Domain< 1 %
- Numeric Row Splitter< 1 %
Parquet Reader< 1 %- Nominal Row Filter Configuration< 1 %
Random Forest Predictor< 1 %Number To String (PMML)< 1 %- Parallel Coordinates Plot (JavaScript)< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
Extract Date&Time Fields< 1 %- Database List Tables (Legacy)< 1 %
- Naive Bayes Predictor< 1 %
String Replace (Dictionary)< 1 %CASE Switch Data (Start)< 1 %- ROC Curve (legacy)< 1 %
Parquet Reader< 1 %- Random Number Assigner (Apache)< 1 %
- Tag Cloud (JavaScript)< 1 %
- JSON Path< 1 %
JSON Reader< 1 %- MapQuest Geocoder< 1 %
- Normalize Plates (Z-Score)< 1 %
- Variable Loop End< 1 %
- Table Validator< 1 %
Color Appender< 1 %- R Snippet< 1 %
CSV Reader< 1 %Database Connection Table Reader< 1 %- X-Partitioner< 1 %
- Random Forest Predictor< 1 %
Number To String< 1 %- Ungroup< 1 %
Rank Correlation< 1 %- End IF< 1 %
Excel Reader (XLS)< 1 %- Decision Tree View (JavaScript)< 1 %
- Lift Chart (JavaScript)< 1 %
- Disturber Node< 1 %
- Date&Time Shift< 1 %
XML Reader< 1 %- R-Group Decomposer< 1 %
- Database List Primary Keys (Legacy)< 1 %
- Outlier Removal< 1 %
- File Meta Info (legacy)< 1 %
- String to URI< 1 %
Variable to Table Row< 1 %Database Looping< 1 %- Extract System Properties< 1 %
List Files< 1 %Loop End (2 ports)< 1 %- Loop End (Column Append)< 1 %
Recursive Loop End (2 ports)< 1 %Variable Loop End< 1 %- Naive Bayes Learner< 1 %
- Fuzzy c-Means< 1 %
- K Nearest Neighbor< 1 %
- Logistic Regression Predictor< 1 %
Scorer< 1 %- Entropy Scorer< 1 %
Numeric Scorer< 1 %- PCA Apply< 1 %
- Tree Ensemble Predictor< 1 %
- Random Forest Predictor (Regression)< 1 %
Concatenate (Optional in)< 1 %- Bootstrap Sampling< 1 %
- Column to Grid< 1 %
- Edit Nominal Domain< 1 %
- Interactive HiLite Collector< 1 %
- Rank< 1 %
- String Splitter (Regex)< 1 %
- Top k Row Filter< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Independent groups t-test< 1 %
CASE Switch Data (End)< 1 %- Cache< 1 %
- Extract Table Dimension< 1 %
- Counter Generation< 1 %
- Conditional Label Assigner< 1 %
- Stresser< 1 %
- Mahalanobis Distance< 1 %
- Scatter Plot (Plotly)< 1 %
- Sunburst Chart (JavaScript)< 1 %
- Surface Plot (Plotly)< 1 %
- Violin Plot (Plotly)< 1 %
- DL4J Feedforward Predictor (Classification) (legacy)< 1 %
- H2O Random Forest Learner< 1 %
- External SSH Tool< 1 %
- Java Snippet (simple)< 1 %
- Dictionary Tagger< 1 %
- String to Term< 1 %
- Google Analytics Query (legacy)< 1 %
- Value Filter Definition (legacy)< 1 %
- Boolean Input (legacy)< 1 %
- String Input (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
- Tile View (JavaScript)< 1 %
- Table to JSON< 1 %
- Container Input (JSON)< 1 %
- Columns to JSON< 1 %
- Python Edit Variable (legacy)< 1 %
- Webpage Retriever< 1 %
- Duration to Number< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Date Field Extractor (legacy)< 1 %
- Moving Aggregator< 1 %
Location Extractor< 1 %Reverse Location Lookup< 1 %- Fast Fourier Transform (FFT)< 1 %
- Load Text Files< 1 %
- Range Filter< 1 %
- Python Snippet 2:2< 1 %
- XLS Named Range Reader< 1 %
- Create Collection Column< 1 %
Variable to Table Column< 1 %- CSV Writer< 1 %
- Java Edit Variable< 1 %
- Feature Selection Filter< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Generic Loop Start< 1 %
- PNN Learner (DDA)< 1 %
- MultiLayerPerceptron Predictor< 1 %
- SVM Predictor< 1 %
- Random Forest Learner< 1 %
- CAIM Binner< 1 %
CASE Switch Variable (Start)< 1 %- Timer Info< 1 %
- Conditional Box Plot (legacy)< 1 %
- Size Manager< 1 %
- Capture Workflow End< 1 %
- Workflow Executor< 1 %
- One Row to Many< 1 %
- Distance Matrix Calculate< 1 %
- Keras Network Executor< 1 %
- 2D Density Plot (Plotly)< 1 %
- 3D Scatter Plot (Plotly)< 1 %
- Radar Plot (Plotly)< 1 %
- Read Excel Sheet Names< 1 %
- Radar Plot Appender< 1 %
- Case Converter< 1 %
- Bag Of Words Creator< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- List Files/Folders< 1 %
- Files/Folders Meta Info< 1 %
- Path to String< 1 %
- Google Sheets Reader< 1 %
- Date&Time Configuration< 1 %
- Value Selection Configuration< 1 %
- Tagged Document Viewer< 1 %
- Interactive Value Filter Widget< 1 %
- Column Selection Widget< 1 %
- Multiple Selection Widget< 1 %
- Single Selection Widget< 1 %
- JSON Reader< 1 %
- JSON to XML< 1 %
- Feature Calculator (BETA)< 1 %
MongoDB Reader< 1 %- Parameter Optimization Loop Start< 1 %
- String to Duration< 1 %
- Extract Time Window (legacy)< 1 %
- XGBoost Predictor (Regression)< 1 %
- Discretise< 1 %
- RDKit Diversity Picker< 1 %
Views
- Interactive View: Data Explorer View
The interactive view consists of three tabs: a Statistics tab, a Nominal tab, and a Data Preview tab. The Statistics and Nominal tabs sum up the information in each column. The user can then decide which columns to include in further analysis.
The Numeric tab shows the main statistical properties of the numerical data, such as minimum, maximum, median (optional), standard deviation, variance, skewness, kurtosis, overall sum, number of zero values, number of missing values, number of not-an-object values, as well as positive and negative infinity values. For each column, the node also calculates a histogram showing the value distribution.
The Nominal tab lists the main properties of the nominal values, such as the number of missing values, unique values, and top n most frequent and infrequent values. In addition, for each data column there is a histogram showing the frequencies with which values occur in this column.
The Data Preview tab shows the data selected for preview.
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- [Latest] Consolidated 3 Mar 1210KNIME Hub
- 0_install_extensionsKNIME Hub
- 00_Install_ExtensionsKNIME Hub
- 00_SetupKNIME Hub
- Show all 1067 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.