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
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:
0
Answers
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.
Lindon Ventures
Data Science Consulting from Certified RapidMiner Experts