Icon

Compute_​Division_​between_​tables

Compute division between two tables
Get the average value for each product in a column and transpose it Divide the value in each column in table 2 by the respective average extracted in Table 1 Example Table Manipulation Goal: Divide the value of each product in table 2 by the average value of each product in table 1Table 1Table 2Transpose(rows to columns)Joining bothtables on Product NamesComputing the averageRenamingColumns forinterpretabilityUsing namesas RowIDsTable Creator Table Creator Transpose Fix Headers String To Number String To Number Math Formula(Multi Column) Joiner Math Formula(Multi Column) Column Rename RowID Get the average value for each product in a column and transpose it Divide the value in each column in table 2 by the respective average extracted in Table 1 Example Table Manipulation Goal: Divide the value of each product in table 2 by the average value of each product in table 1Table 1Table 2Transpose(rows to columns)Joining bothtables on Product NamesComputing the averageRenamingColumns forinterpretabilityUsing namesas RowIDsTable Creator Table Creator Transpose Fix Headers String To Number String To Number Math Formula(Multi Column) Joiner Math Formula(Multi Column) Column Rename RowID

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: Ana Vedoveli
Created at: 2019-07-04
On NodePit since: 2019-10-03
Last update: 2024-12-17
Created with KNIME version: v4.0.0
Tags: ETLForum

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

Try NodePit Runner!