How to multiply many columns

olgakulesza2

Hello,

I'm new at rapid miner. I have a problem with multiplying values from columns. 

Let's imagine I have 4 columns: A,B,C,D. I want to multiply each column B,C,D with A. 

I know I can make it by using 'Generate Attributes', but I have about 100 columns co it is a little bit hard to do it. What's more I would like to have new values of that columns, not the new additional columns. 

For example I have: 

A        B         C        D                                                                   

3       1           2         1                                                                  

4       2           2         1                                                                  

5       3           1         2       

and what I want to have is:       

A        B         C        D   

3         3         6         3

4         8         8         4

5        15       5         10

I would be grateful for any advice.

 

Telcontar120

Just use "Generate Attributes" inside a "Loop Attributes" and you only have to configure it once and RapidMiner will do all the rest of the work for you.  And if you want to overwrite your original attributes, just use the same attribute name with a macro inside the Loop Attributes (if you wanted a new name you could just use the macro and add "_new" to the end).