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 Predecessors
- Empty Table Switch7 %
- Table Creator4 %
- GroupBy3 %
- String Manipulation2 %
Row Filter (deprecated)2 %- Column Filter2 %
- Duplicate Row Filter2 %
Variable to Table Row2 %- Empty Table Creator2 %
CSV Reader2 %- Constant Value Column1 %
- Sorter1 %
Table Column to Variable1 %- Rule Engine1 %
- Group Loop Start1 %
- Create Table Structure1 %
- Table Row to Variable1 %
String To Number1 %Row Splitter (deprecated)1 %- Rule-based Row Filter1 %
- Concatenate< 1 %
- Joiner< 1 %
- IF Switch< 1 %
- Excel Reader< 1 %
Column Rename< 1 %- Missing Value< 1 %
- DB Query Reader< 1 %
- Reference Row Filter< 1 %
Joiner< 1 %- Unpivot< 1 %
Table Row To Variable Loop Start< 1 %- Double to Integer< 1 %
- Column Expressions< 1 %
- Column Aggregator< 1 %
- Column Resorter< 1 %
- Partitioning< 1 %
- Chunk Loop Start< 1 %
Generic Loop Start< 1 %- Rank< 1 %
- Rule-based Row Splitter< 1 %
- End IF< 1 %
- Math Formula< 1 %
XLS Reader< 1 %- Integer Input (legacy)< 1 %
- DB Reader< 1 %
- Is Empty< 1 %
- Table Manipulator< 1 %
- Table Difference Finder< 1 %
- DB Connection Closer< 1 %
- Column Renamer< 1 %
- Add Empty Rows< 1 %
- Math Formula (Variable)< 1 %
- Java Snippet Row Filter< 1 %
- Math Formula (Multi Column)< 1 %
- Recursive Loop Start< 1 %
- Legacy Date&Time to Date&Time< 1 %
Table Column to Variable< 1 %- String to Number< 1 %
- Domain Calculator< 1 %
- Value Counter< 1 %
- CSV Reader< 1 %
- Table Validator< 1 %
- Integer Configuration< 1 %
- Create Date&Time Range< 1 %
- URL to File Path< 1 %
- Configurable IF/CASE Switch< 1 %
- Catch Errors (Data Ports)< 1 %
Counting Loop Start< 1 %- RowID< 1 %
- String Replacer< 1 %
- String to Date&Time< 1 %
- Try (Data Ports)< 1 %
Recursive Loop Start< 1 %- Ungroup< 1 %
- Date&Time Configuration< 1 %
- Table Column to Variable< 1 %
- Variable to Table Row< 1 %
- Table Reader< 1 %
- Generic Loop Start< 1 %
- Column Appender< 1 %
- Color Manager< 1 %
- DB Insert< 1 %
- Salesforce Simple Query< 1 %
- Nominal Value Row Splitter< 1 %
- Inject Variables (Data)< 1 %
Database Connection Table Reader< 1 %File Reader< 1 %- Java Edit Variable< 1 %
- Java Snippet< 1 %
Interval Loop Start< 1 %- Column List Loop Start< 1 %
Concatenate (Optional in)< 1 %- Column Combiner< 1 %
Number To String< 1 %- Column Name Extractor< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Merger< 1 %
- Nominal Value Row Filter< 1 %
- Pivot< 1 %
- Column Splitter< 1 %
- Table Transposer< 1 %
- Extract Table Dimension< 1 %
- Counter Generation< 1 %
Excel Reader (XLS)< 1 %- Java IF (Table)< 1 %
- Date&Time-based Row Filter< 1 %
Recursive Loop Start (2 ports)< 1 %- Column Comparator< 1 %
- Number to String< 1 %
- Cross Joiner< 1 %
- String Manipulation (Variable)< 1 %
- Google Analytics Query (legacy)< 1 %
- Date&Time to String< 1 %
- File Reader< 1 %
- Loop End< 1 %
- Counting Loop Start< 1 %
- Variable Loop End< 1 %
- Table Row to Variable Loop Start< 1 %
- CASE Switch Start< 1 %
- Merge Variables< 1 %
- Parallel Chunk End< 1 %
- Variable Expressions< 1 %
- List Files/Folders< 1 %
- Integer Widget< 1 %
- Molecular Properties< 1 %
- Excel Writer< 1 %
- CASE Switch End< 1 %
- Row to Column Names< 1 %
- Multiple Selection Widget< 1 %
- MMP Molecule Fragment (RDKit)< 1 %
- Read Excel Sheet Names< 1 %
- Path to String< 1 %
- Window Loop Start< 1 %
- Image Writer (Table)< 1 %
List Files< 1 %- Column Rename (Regex)< 1 %
- Number Rounder< 1 %
- Extract Table Spec< 1 %
- Random Number Assigner (Apache)< 1 %
- RDKit One Component Reaction< 1 %
- Extract Variables (Data)< 1 %
Table Reader< 1 %- Cell Splitter< 1 %
- Statistics< 1 %
- Line Plot (JavaScript)< 1 %
- Table to JSON< 1 %
- Delete Files (legacy)< 1 %
- URI Port to Variable< 1 %
Recursive Loop End (2 ports)< 1 %- Linear Regression Learner< 1 %
- Normalizer< 1 %
- PMML Ensemble to Table< 1 %
Excel Reader (XLS)< 1 %- JSON to Table< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Row Filter (Labs)< 1 %
- Data Generator< 1 %
- TimeDelay Loop Start< 1 %
- String Input (legacy)< 1 %
- Python Script (legacy)< 1 %
Cell Splitter< 1 %- Column Auto Type Cast< 1 %
- Table Validator (Reference)< 1 %
- Target Shuffling< 1 %
CASE Switch Data (Start)< 1 %- Parallel Chunk Start< 1 %
- Date&Time Shift< 1 %
- Mask Date/Time (legacy)< 1 %
- Wait...< 1 %
- PCA Apply< 1 %
Cell Replacer< 1 %- Reference Column Filter< 1 %
- Shuffle< 1 %
CASE Switch Data (End)< 1 %Excel Reader (XLS)< 1 %- PDF Parser< 1 %
- Tika Parser< 1 %
- Bag Of Words Creator< 1 %
- Date&Time Input (legacy)< 1 %
- Date&Time Difference< 1 %
- Table to HTML String< 1 %
- Data Explorer< 1 %
- JSON Path< 1 %
- Split Collection Column< 1 %
Table Row to Variable< 1 %Database Reader< 1 %Database Writer< 1 %- Loop End (Column Append)< 1 %
Loop End< 1 %Column Appender< 1 %- Lag Column< 1 %
- Many to One< 1 %
- Row Sampling< 1 %
- Rule Engine Variable< 1 %
- Java Snippet (simple)< 1 %
- Java Edit Variable (simple)< 1 %
- String to JSON< 1 %
- Extract Time Window (legacy)< 1 %
- Moving Aggregator< 1 %
- Molecule to CDK< 1 %
- XLS Control Table Generator< 1 %
- Molecule Properties< 1 %
IF Switch (Flow Variable Value)< 1 %- Range Splitter< 1 %
- Unzip Files (legacy)< 1 %
Catch Errors (DB Ports)< 1 %- Catch Errors (Var Ports)< 1 %
- Active Branch Inverter< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %Variable to Table Row< 1 %Line Reader< 1 %Variable Loop End< 1 %- Fuzzy c-Means< 1 %
- Polynomial Regression Learner< 1 %
Random Forest Learner< 1 %- Case Converter< 1 %
- Category to Number< 1 %
- Edit Numeric Domain< 1 %
- Equal Size Sampling< 1 %
- Extract Missing Value Cause< 1 %
- Filter Apply< 1 %
- Reference Row Splitter< 1 %
- Reference Column Resorter< 1 %
- Numeric Outliers< 1 %
CASE Switch Variable (Start)< 1 %- Cache< 1 %
Merge Variables< 1 %- Spark to Table< 1 %
- DB Writer< 1 %
- Gamma Distributed Assigner< 1 %
- Distance Matrix Reader< 1 %
- Index Query< 1 %
- Column Filter (legacy)< 1 %
- Table View (JavaScript)< 1 %
- ROC Curve (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Date&Time Widget< 1 %
- Labeling Arithmetic< 1 %
- R Snippet< 1 %
- GET Request< 1 %
- String to Date/Time (legacy)< 1 %
- Remove Empty Rows< 1 %
- Create Collection Column< 1 %
- Try (Variable Ports)< 1 %
- Image to Table< 1 %
Simple File Reader< 1 %- Line Reader< 1 %
Table Writer< 1 %- Variable Creator< 1 %
Recursive Loop End< 1 %- Numeric Scorer< 1 %
- One to Many< 1 %
- Linear Correlation< 1 %
- Constant Value Column Filter< 1 %
- String Manipulation (Multi Column)< 1 %
- Top k Row Filter< 1 %
- DB Delete (Table)< 1 %
- Parameterized DB Query Reader< 1 %
- External Tool< 1 %
- String to Path< 1 %
- Google Sheets Reader< 1 %
- Boolean Configuration< 1 %
- Value Filter (legacy)< 1 %
- XPath< 1 %
- Navigate< 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.