Icon

20220523 Pikairos How to compute mathematical functions based on condition of the column names

There has been no description set for this workflow's metadata.

Your dataSplit columnsbased on Baseline orDayLoop overBaseline ColumnsExtractBaseline ColumnHeader toalways have thesame Column HeaderRename Column Namefrom Baseline to Day*replace($Baseline0$, "Baseline", "Day*")Set this Column Name Conditionto a variableFilter Columnsbased on PreviouslyBuild ConditionAppend theBaseline Columnto its relatedDay COlumnsDo the substractionbetween Day Columnsand CurrentBaseline ColumnKeep only theDelta calculatedColumnLoop overall theBaseline ColumnsRename CalculatedColumns toDelta ColumnsCSV Reader Column Splitter Column ListLoop Start ExtractColumn Header String Manipulation Table Rowto Variable Column Filter Column Appender Math Formula(Multi Column) Column Filter Loop End (ColumnAppend) Column Rename(Regex) Your dataSplit columnsbased on Baseline orDayLoop overBaseline ColumnsExtractBaseline ColumnHeader toalways have thesame Column HeaderRename Column Namefrom Baseline to Day* replace($Baseline0$, "Baseline", "Day*")Set this Column Name Conditionto a variableFilter Columnsbased on PreviouslyBuild ConditionAppend theBaseline Columnto its relatedDay COlumnsDo the substractionbetween Day Columnsand CurrentBaseline ColumnKeep only theDelta calculatedColumnLoop overall theBaseline ColumnsRename CalculatedColumns toDelta ColumnsCSV Reader Column Splitter Column ListLoop Start ExtractColumn Header String Manipulation Table Rowto Variable Column Filter Column Appender Math Formula(Multi Column) Column Filter Loop End (ColumnAppend) Column Rename(Regex)

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: Molina
Created at: 2022-05-23
On NodePit since: 2022-05-23
Last update: 2024-04-26
Created with KNIME version: v4.5.2

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

Try NodePit Runner!