The XLS Control Table Generator node takes an input data table and transforms it to an XLS Control Table, meaning it exchanges the column names to A, B, C, ... and the row IDs to 1, 2, 3, ... just like they would appear when opening the xlsx file in a spreadsheet application.
Optionally you can unpivot the table as well to make use of Rule Engine nodes later for flexible and dynamic XLS formatting workflows. A second operation type allows to pivot this special table layout back to the final desired XLS Control Table structure.Options
Operation Type (automatically set based on the provided input table)
Shift Rows Option
Result Table Structure Options
Contradiction Resolution Strategy at Operation Type 'long to wide'
Popular Predecessors
- Rule Engine19 %
- Excel Reader10 %
- Column Expressions6 %
- Table Creator4 %
- Column Filter4 %
- Column Resorter4 %
- Row Filter3 %
- Excel Writer3 %
- Table Manipulator2 %
- Concatenate2 %
Column Rename2 %- Missing Value2 %
- Sorter2 %
- String Manipulation (Multi Column)2 %
- Table Reader1 %
- Constant Value Column Filter1 %
- Constant Value Column1 %
- Group Loop Start1 %
- Python Source (legacy)1 %
- GroupBy1 %
- String to Number1 %
- String Manipulation1 %
Table Reader< 1 %- Math Formula< 1 %
- XLS Control Table Generator< 1 %
- Rule Engine (Dictionary)< 1 %
- Joiner< 1 %
- Column Appender< 1 %
- XLS Control Table from Cell Range< 1 %
- Rule-based Row Splitter< 1 %
- CSV Reader< 1 %
- Column Auto Type Cast< 1 %
- String Replacer< 1 %
- One Row to Many< 1 %
- XLS Control Table Merger< 1 %
- Loop End (Column Append)< 1 %
- Duplicate Row Filter< 1 %
- RowID< 1 %
- Variable Loop End< 1 %
- Number to String< 1 %
- Add Empty Rows< 1 %
- Column Name Extractor< 1 %
- Column Rename (Regex)< 1 %
- String Manipulation (Variable)< 1 %
- Rule-based Row Filter< 1 %
Excel Reader (XLS)< 1 %Read Excel Sheet Names (XLS)< 1 %- Chunk Loop Start< 1 %
- Reference Column Resorter< 1 %
- CASE Switch Start< 1 %
- Python Script (legacy)< 1 %
- Date&Time to String< 1 %
- Loop End< 1 %
- Wait...< 1 %
- Column Renamer (Dictionary)< 1 %
- Pivot< 1 %
- Column Splitter< 1 %
- Table Transposer< 1 %
- Empty Table Creator< 1 %
- Math Formula (Multi Column)< 1 %
- Table Row to Variable< 1 %
- DB Query Reader< 1 %
- Path to String (Variable)< 1 %
- Catch Errors (Data Ports)< 1 %
- Column Renamer< 1 %
- Round Double< 1 %
Excel Sheet Appender (XLS)< 1 %- Data Generator< 1 %
- Google Sheets Reader< 1 %
- Column Comparator< 1 %
- Category to Number< 1 %
- Read Excel Sheet Names< 1 %
- Date&Time Difference< 1 %
- Date&Time-based Row Filter< 1 %
- String to URI< 1 %
Loop End< 1 %Joiner< 1 %- Unpivot< 1 %
- Java Edit Variable (simple)< 1 %
- Table Editor (JavaScript)< 1 %
- XLS Border Formatter< 1 %
- Try (Data Ports)< 1 %
File Reader< 1 %- Extract Missing Value Cause< 1 %
- Network Component Splitter< 1 %
Table Row To Variable Loop Start< 1 %Table Writer< 1 %- Java Snippet< 1 %
Recursive Loop End< 1 %Concatenate (Optional in)< 1 %- Column Combiner< 1 %
String To Number< 1 %Column Appender< 1 %- Nominal Value Row Filter< 1 %
- Reference Row Filter< 1 %
- End IF< 1 %
- IF Switch< 1 %
- Color Manager< 1 %
- DB Reader< 1 %
- TimeDelay Loop Start< 1 %
Excel Reader (XLS)< 1 %Excel Writer (XLS)< 1 %- Triple File Reader< 1 %
- String to Date&Time< 1 %
- Mass Calculator< 1 %
- XLS Format Merger< 1 %
- XLS Sheet Selector< 1 %
- Dropbox Search< 1 %
- Inject Variables (Data)< 1 %
- File Reader (Complex Format)< 1 %
- Table Row to Variable Loop Start< 1 %
- Domain Calculator< 1 %
- Missing Value Column Filter< 1 %
- Row Splitter< 1 %
- Missing Value (Apply)< 1 %
CASE Switch Data (Start)< 1 %Color Appender< 1 %- Counter Generation< 1 %
- Random Number Assigner (Apache)< 1 %
- External Tool< 1 %
- Column Filter Configuration< 1 %
- Legacy Date&Time to Date&Time< 1 %
Views
- This node has no views
Workflows
01_Correlation_MatrixKNIME Hub- 01_XLS_ControlTablesKNIME Hub
- 02 - create control table for taggingKNIME Hub
- 02_Pretty_TableKNIME Hub
- 02_Pretty_TableKNIME Hub
- Show all 148 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.