Adds a certain number of empty rows with missing values (or a constant) to the input table. This can be useful when used in a report table to ensure that a table has a minimum number of rows, which are then shown as blank rows. The content of the appended rows can be defined in the dialog, the default is to fill the corresponding cells with missing values. Note that the reporting engine allows you to format cells containing missing values (or any other specific value) using the "Map" feature. For instance, if you want to format missing values (shown as NaN in the report) as blank fields, add a map rule isNaN(row["Column x"]), which needs to evaluate to True.
Options
Popular Successors
- Concatenate5 %
- End IF5 %
- Missing Value4 %
- Constant Value Column3 %
- Java Snippet3 %
- Column Expressions3 %
- Sorter3 %
- Rule Engine3 %
- String Manipulation3 %
Excel Writer (XLS)2 %Table Row to Variable2 %- Loop End2 %
- RowID2 %
- GroupBy2 %
Column Rename2 %- Column Filter1 %
- Column Appender1 %
- Cross Joiner1 %
Row Filter (deprecated)< 1 %- Math Formula< 1 %
- Joiner< 1 %
- Counter Generation< 1 %
- Excel Writer< 1 %
- Table Creator< 1 %
- DB Insert< 1 %
- Send Email< 1 %
- Table Transposer< 1 %
String To Number< 1 %- CASE Switch End< 1 %
Python Script (1⇒1)< 1 %- Table Row to Variable< 1 %
- Cell Splitter< 1 %
- Table Editor (JavaScript)< 1 %
- Active Branch Inverter< 1 %
- Variable to Table Column< 1 %
Number To String< 1 %- String to Date&Time< 1 %
- Nominal Value Row Filter< 1 %
Row Splitter (deprecated)< 1 %- Rank< 1 %
- Top k Row Filter< 1 %
- Table View (JavaScript)< 1 %
- Fill Holes< 1 %
- Number to String< 1 %
- Table Validator< 1 %
- Math Formula (Variable)< 1 %
Excel Sheet Appender (XLS)< 1 %- Java Snippet (simple)< 1 %
Column Appender< 1 %- Reference Column Filter< 1 %
- Math Formula (Multi Column)< 1 %
- 1D Kernel Density Plot< 1 %
Recursive Loop Start (2 ports)< 1 %- Add Empty Rows< 1 %
- Column Resorter< 1 %
- Rule-based Row Filter< 1 %
- Empty Table Switch< 1 %
- DB Writer< 1 %
Excel Writer (XLS)< 1 %- Text Output Widget (legacy)< 1 %
- Variable to Table Row< 1 %
- CSV Writer< 1 %
Loop End (2 ports)< 1 %- Column Name Extractor< 1 %
- Reference Row Splitter< 1 %
- Table Manipulator< 1 %
- Reference Column Resorter< 1 %
- Column Splitter< 1 %
- Unpivot< 1 %
- IF Switch< 1 %
- Merge Variables< 1 %
- HeatMap (JFreeChart)< 1 %
- Strings to Binary Objects< 1 %
Loop End< 1 %- Group Loop Start< 1 %
- Cell Splitter By Position< 1 %
- Column Aggregator< 1 %
- Column Renamer (Dictionary)< 1 %
- Table Validator (Reference)< 1 %
- Missing Value (Apply)< 1 %
- Extract Table Dimension< 1 %
- Autocomplete Text Widget< 1 %
- Excel Reader< 1 %
- R Snippet< 1 %
- Date/Time Shift (legacy)< 1 %
- Moving Aggregator< 1 %
- XLS Control Table Generator< 1 %
- Catch Errors (Data Ports)< 1 %
- Table Column to Variable< 1 %
- CSV Reader< 1 %
- Table Writer< 1 %
- Loop End (Column Append)< 1 %
- Counting Loop Start< 1 %
- Chunk Loop Start< 1 %
- Recursive Loop End< 1 %
- Variable Loop End< 1 %
- Table Row to Variable Loop Start< 1 %
- Regression Predictor< 1 %
Concatenate (Optional in)< 1 %Cell Replacer< 1 %Cell Splitter< 1 %- Column Auto Type Cast< 1 %
- String to Number< 1 %
- Lag Column< 1 %
- Column Rename (Regex)< 1 %
- Duplicate Row Filter< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
Joiner< 1 %- Partitioning< 1 %
- Pivot< 1 %
- Row to Column Names< 1 %
- Row Sampling< 1 %
- String Manipulation (Multi Column)< 1 %
- String Manipulation (Variable)< 1 %
- String Replacer< 1 %
- Cell Updater< 1 %
- Table Difference Finder< 1 %
- Value Counter< 1 %
- Rule-based Row Splitter< 1 %
- Rule Engine (Dictionary)< 1 %
- CASE Switch Start< 1 %
CASE Switch Data (End)< 1 %- Random Number Assigner< 1 %
- Random Label Assigner< 1 %
- Bar Chart (JavaScript)< 1 %
- Variable Expressions< 1 %
- Path to String< 1 %
- String to Path< 1 %
- Google Sheets Updater< 1 %
- Value Selection Widget< 1 %
- Table to JSON< 1 %
- Date&Time to String< 1 %
- ARIMA Predictor< 1 %
- Split Collection Column< 1 %
Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %Variable to Table Row< 1 %Parameterized Database Query< 1 %Variable Condition Loop End< 1 %- Association Rule Learner< 1 %
- Bootstrap Sampling< 1 %
- Column Merger< 1 %
- Edit Numeric Domain< 1 %
- Rule Engine Variable< 1 %
- Interactive Table (legacy)< 1 %
- DB Merge< 1 %
XLS Writer< 1 %- List Files/Folders< 1 %
- R Snippet< 1 %
- Create Collection Column< 1 %
- Breakpoint< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %Table Writer< 1 %Generic Loop Start< 1 %Regression Predictor< 1 %- Binner (Dictionary)< 1 %
- Category to Number< 1 %
- Domain Calculator< 1 %
- Reference Row Filter< 1 %
- Number Rounder< 1 %
Merge Variables< 1 %- Color Manager< 1 %
- Parallel Chunk End< 1 %
- PostgreSQL Connector< 1 %
- Random Boolean Assigner< 1 %
- Generic Web Service Client< 1 %
Excel Sheet Appender (XLS)< 1 %- Java IF (Table)< 1 %
- Column Filter Configuration< 1 %
- Column Filter (legacy)< 1 %
- Container Output (JSON)< 1 %
- POST Request< 1 %
Extract Date&Time Fields< 1 %Dumb Joiner< 1 %- Is Empty< 1 %
- Benchmark End< 1 %
- 2D/3D Scatterplot< 1 %
Database Update< 1 %- Java Edit Variable< 1 %
Counting Loop Start< 1 %Recursive Loop End< 1 %Recursive Loop Start< 1 %Scorer< 1 %- Set Operator< 1 %
- Statistics< 1 %
- Interactive Pie chart (legacy)< 1 %
Color Appender< 1 %- One Row to Many< 1 %
- Random Item Inserter< 1 %
- Numeric Distances< 1 %
- Similarity Search< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Radar Plot Appender< 1 %
- Value Selection Configuration< 1 %
- Text Output (legacy)< 1 %
- Nominal Row Filter Widget< 1 %
- String to JSON< 1 %
- JSON Path< 1 %
- R View (Table)< 1 %
- Date&Time-based Row Filter< 1 %
- Date&Time Shift< 1 %
- Moving Average< 1 %
- String to Date/Time (legacy)< 1 %
- HTTP Retriever< 1 %
- WebDriver Factory< 1 %
- Fast Fourier Transform (FFT)< 1 %
- Database Table Exists IF Switch (Legacy)< 1 %
- Plate Row Converter< 1 %
- Range Filter< 1 %
- R Plot< 1 %
- Write To Excel Template (deprecated)< 1 %
- ARIMA Learner< 1 %
- Copy/Move Files (legacy)< 1 %
- URL to File Path (Variable)< 1 %
- Try (Data Ports)< 1 %
Variable to Table Column< 1 %- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %- ARFF Writer< 1 %
CSV Writer< 1 %Database Reader< 1 %Database Writer< 1 %Database Looping< 1 %File Reader< 1 %Interval Loop Start< 1 %- Column List Loop Start< 1 %
- Recursive Loop Start< 1 %
- Fuzzy c-Means< 1 %
- k-Means< 1 %
- Decision Tree Predictor< 1 %
PCA Apply< 1 %- Linear Regression Learner< 1 %
Logistic Regression Learner< 1 %- Numeric Scorer< 1 %
- SMOTE< 1 %
- SOTA Learner< 1 %
- Gradient Boosted Trees Learner< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Random Forest Learner< 1 %
- Simple Regression Tree Predictor< 1 %
- Perl Scripting< 1 %
- Create Bit Vector< 1 %
- Column Combiner< 1 %
- Many to One< 1 %
- One to Many< 1 %
- HiLite Row Splitter< 1 %
- Missing Value Column Filter< 1 %
- Row Filter (Labs)< 1 %
- Denormalizer< 1 %
- Normalizer< 1 %
String To Number (PMML)< 1 %- String Splitter (Regex)< 1 %
- Numeric Row Splitter< 1 %
- Shuffle< 1 %
- Ruleset Editor< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Create Temp Dir (legacy)< 1 %
- Conditional Box Plot (legacy)< 1 %
- Lift Chart (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
- Capture Workflow Start< 1 %
- SDF Writer< 1 %
- Amazon Comprehend (Entity Tagger)< 1 %
- Parallel Chunk Start< 1 %
- DB Connection Closer< 1 %
- Parameterized DB Query Reader< 1 %
- DB Reader< 1 %
- DB Update< 1 %
DB Table Creator< 1 %- Empty Table Creator< 1 %
- Gaussian Distributed Assigner< 1 %
- One Rule Inserter< 1 %
- Random Label Assigner (Data)< 1 %
- Random Number Assigner (Apache)< 1 %
- TimeDelay Loop End< 1 %
- Time Series Generator< 1 %
- Distance Matrix Calculate< 1 %
- Box Plot (JavaScript)< 1 %
- Conditional Box Plot (JavaScript)< 1 %
- Table to PMML Ensemble< 1 %
PMML Ensemble Predictor< 1 %XLS Sheet Appender< 1 %Excel Reader (XLS)< 1 %- Java Snippet Row Filter< 1 %
- Dictionary Tagger< 1 %
- Strings to Document< 1 %
- Tags to String< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Files/Folders Meta Info< 1 %
- Path to URI< 1 %
- Column Selection (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Tile View (JavaScript)< 1 %
- Container Output (Table)< 1 %
- JSON Transformer< 1 %
- Columns to JSON< 1 %
- Kafka Producer< 1 %
- Node Name Filter< 1 %
- Python Script (legacy)< 1 %
- Python Source (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- Date&Time to legacy Date&Time< 1 %
- Modify Date< 1 %
- Mask Date/Time (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- XML Row Combiner< 1 %
- String to XML< 1 %
- XPath< 1 %
- RDKit Interactive Table< 1 %
Views
- This node has no views
Workflows
00_Download_DatasetKNIME Hub- 00_Download_DatasetKNIME Hub
- 00_Download_DatasetKNIME Hub
00_xplan sf dbconv-insert via xport-AccountKNIME Hub- 01_aplicacoesKNIME Hub
- Show all 360 workflows
Links
- No links available
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.