The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Convert Excel Formulas

mhalcro1mhalcro1 Member Posts: 1 Learner I

Hi, I'm an excel user and complete RM novice; I've got a large spreadsheet I'm trying to convert in RM to speed things up but can't get the formula to calculate the same.  It's not complex - it's adding up a series of cells; I'm looking for help to convert from Excel into RM language - please see Excel formula sample below (all cells are numerical)

=AB3+AE3+AJ3+AM3+AR3+AU3+AZ3+BC3+0.2*BH3+BK3+0.2*BP3+BS3+0.2*BX3+CA3+EE3*CF3+CI3+EE3*CM3+CP3+EE3*CT3+CW3+EE3*DA3+DD3

Any help greatly received!

TIA

Tagged:

Answers

  • Telcontar120Telcontar120 RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn
    The operator Generate Aggregation is one operator that can be used, if you only need one operation at a time (such as sum or average) across multiple columns (called attributes in RapidMiner).
    However, for a formula like the one you have above, in which there are different operations as well as some hard-coded numerical scaling factors, then you would need to use Generate Attributes.  In that operator you can define a new attribute as a function of any number of existing attributes and can specify whatever sequence of operations that you want.  Take a look at the sample process in the help for that operator to see how it works.
      
    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
Sign In or Register to comment.