Icon

20210907 - Transform Data

create Summary row Manipulate the "sample data" columns Manipulate the "constant" columns bring it all together Step 1 Step 2 Step 3 Step 4 Sample Data Filter on 00444QRename all the requiredcolumnsRemove ColQCurrent DateTimeColumn ADate as a stringin dd.mm.yyyy formatBLDATColumn BClone Date columnas BUDATColumn CColumn EColumn DColumn FColumn MCombine test datawith single row of additionalvaluesAdjust orderingWrite it outColumn ISum of WRBTRand clone first value of all other columnsMake WRBTRnegativePut total row on the endModifySGTXTModify KONTOModify KOSTL(what value should go here?)Modify ZUONRmake blank Table Creator Row Filter Column Rename Column Filter Create Date&TimeRange Date&Time to String Rule Engine String Manipulation ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column Cross Joiner Column Resorter CSV Writer ConstantValue Column GroupBy Math Formula Concatenate Rule Engine ConstantValue Column ConstantValue Column ConstantValue Column create Summary row Manipulate the "sample data" columns Manipulate the "constant" columns bring it all together Step 1 Step 2 Step 3 Step 4 Sample Data Filter on 00444QRename all the requiredcolumnsRemove ColQCurrent DateTimeColumn ADate as a stringin dd.mm.yyyy formatBLDATColumn BClone Date columnas BUDATColumn CColumn EColumn DColumn FColumn MCombine test datawith single row of additionalvaluesAdjust orderingWrite it outColumn ISum of WRBTRand clone first value of all other columnsMake WRBTRnegativePut total row on the endModifySGTXTModify KONTOModify KOSTL(what value should go here?)Modify ZUONRmake blank Table Creator Row Filter Column Rename Column Filter Create Date&TimeRange Date&Time to String Rule Engine String Manipulation ConstantValue Column ConstantValue Column ConstantValue Column ConstantValue Column Cross Joiner Column Resorter CSV Writer ConstantValue Column GroupBy Math Formula Concatenate Rule Engine ConstantValue Column ConstantValue Column ConstantValue Column

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: brian
Created at: 2021-09-07
On NodePit since: 2022-02-06
Last update: 2024-04-28
Created with KNIME version: v4.4.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!