calculate rows

gritsay

Hello! What I can execute add or minus data from rows?

For example, source table:

name    | original series | smoothing series |
param1 |  12                |  13                   
param2 |  11                |  13
param3 |  22                |  21

Postprocessing table:

name    | original series | smoothing series |  sum  | minus|
param1 |  12                |  13                    | 25    |-1      | 
param2 |  11                |  13                    | 24    |-2      |
param3 |  22                |  21                    | 43    | 1      |

Which operator should I use ?

colo

I would suggest the "Generate Attributes" operator. It allows the creation of new attributes while referencing existing attributes and using expressions (including some useful functions) is possible. If you have the attributes "att1" and "att2" you can create the new attributes sum (att1 + att2) and minus (att1 - att2) easily. You should not use blanks or special characters inside the attribute names to avoid problems here.

Regards,
Matthias

gritsay

Thanks! It's very just.