Question on Iterate Column

[dgudkov]

I would unpivot all the PriceX columns, did the multiplication, and then pivoted them back.

See the example below.

multiply columns.morph (2.5 KB)
data.txt (63 Bytes)

If the table is too big to unpivot the entire table at once, you can unpivot it line by line using the technique described in my earlier answer here:

Need some iteration assistance - Iterate Table

Thank you for the detailed description, Keith. There are two ways how to iterate a table and have the row data in the iterated module: Use the “Parameter table” action If the table isn’t too wide, then you can assign all its columns to the respective parameters of the iterated module. In the iterated module, use the “Parameter table” action to create a 1-row table with parameter values as columns. Iterating table with itself Alternatively, derive a table and use the “Iterate table” action to…