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