Icon

03_​Logistics

This example workflow is licensed under

This example workflow is licensed under
the MIT License. See LICENSE.txt in the
workflow directory for details.

cell-level formatting cell background color sheet-level formatting borders Note: Try to run this workflow with thetwo prepared input files input1.xlsx andinput2.xlsx via the input_file workflowvariable. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details.input dataunpivotdefine tagsbolditalicgreypercentfreezeat D2freezedefine backgroundcolors directlybg colordistinct withfirst rowby firstrowonlyperspectivecolor :=alternate 0 | 1color indexto RGBleft join into all cellsby rowonlycoloredcol Bleft join into all cellsself-appendonly aggregation2aggregation2unpivotleft join in to all cellsall borderspivot backpivot backExcel Reader (XLS) XLS ControlTable Generator Rule Engine XLS Font Formatter XLS Formatter(apply) XLS Font Formatter XLS Font Formatter XLS Cell Formatter XLS Control Tablefrom Cell Range XLS SheetProperties Rule Engine Pivoting RowID XLS BackgroundColorizer GroupBy Sorter Rule-basedRow Filter Math Formula Rule Engine Joiner Sorter Row Filter ConstantValue Column Joiner Concatenate Rule-basedRow Filter String Manipulation XLS ControlTable Generator Joiner XLS BorderFormatter XLS ControlTable Generator XLS ControlTable Generator cell-level formatting cell background color sheet-level formatting borders Note: Try to run this workflow with thetwo prepared input files input1.xlsx andinput2.xlsx via the input_file workflowvariable. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details.input dataunpivotdefine tagsbolditalicgreypercentfreezeat D2freezedefine backgroundcolors directlybg colordistinct withfirst rowby firstrowonlyperspectivecolor :=alternate 0 | 1color indexto RGBleft join into all cellsby rowonlycoloredcol Bleft join into all cellsself-appendonly aggregation2aggregation2unpivotleft join in to all cellsall borderspivot backpivot backExcel Reader (XLS) XLS ControlTable Generator Rule Engine XLS Font Formatter XLS Formatter(apply) XLS Font Formatter XLS Font Formatter XLS Cell Formatter XLS Control Tablefrom Cell Range XLS SheetProperties Rule Engine Pivoting RowID XLS BackgroundColorizer GroupBy Sorter Rule-basedRow Filter Math Formula Rule Engine Joiner Sorter Row Filter ConstantValue Column Joiner Concatenate Rule-basedRow Filter String Manipulation XLS ControlTable Generator Joiner XLS BorderFormatter XLS ControlTable Generator XLS ControlTable Generator

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: user
Created at: 2019-03-12
On NodePit since: 2019-07-12
Last update: 2024-04-23
Created with KNIME version: v4.0.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!