I understand how to use iterate column when specifying a column name, I want to do something just a little bit different. I want to apply the same formula to a set of columns using a value in another column in the same row.
Table has 5 columns - Model#, Price1,Price2,Price3,Std_Disc_Pct
I want to replace value in each of the “PriceX” columns using the formula (PriceX value * Std_Disc_Pct value for that row). My issue is that my table has 158 “PriceX” columns and I don’t want to have to create an indiviual calculation for each “PriceX” column, I just want to loop through the columns and apply the formula. The “Std_Disc_Pct” will be different for each row so I need to “row” process the dataset.