IF YOU ❤️ RAPIDMINER, PLEASE HELP US GET TO #1 AGAIN - VOTE IN KDNUGGETS POLL 2019! 🙏 🙏 🙏

Generate a number of macros equal to the number of rows in an Excel table

LG01LG01 Member Posts: 6 Learner I
Hello, I would like using a table of datas and a table of conditions to know if Rapidminer is able to go to read each condition in each exemple of the file "order2"   and to generate a number of macro equal to the number of conditions (exemples). Then I would like Rapidminer to go read all the datas in the "datas2" file and to display a table that only displays the rows with false conditions. Thanks for your help.

Answers

  • mschmitzmschmitz Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 2,020  RM Data Scientist
    Hi,
    Extract Macro is your friend. Afterwards you can use Loop on this.

    BR,
    Martin
    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
  • Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,118   Unicorn
    The "number of examples" (examples are rows) macro value is one of the defaults available in Extract Macro, so that is pretty straightforward.
    For the ones where condition is false, you'll need to set it based on value count and set the condition you want.
    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
    varunm1
Sign In or Register to comment.