filter examples after comparing two example sets

sectynsectyn Member Posts: 25 Maven
I have an example set with some accounts. A second example set with the some of the accounts from the first set and a few others too. In the second example set there can be multiple entries for the same account number. How can I retrieve entries from the second set which have account numbers present in the first set?

Best Answer

  • Options
    MarcoBarradasMarcoBarradas Administrator, Employee, RapidMiner Certified Analyst, Member Posts: 272 Unicorn
    Solution Accepted
    Hi @jennyclub you should use a JOIN operator to gather data from both data sets.


  • Options
    Pradyumna_26Pradyumna_26 Member Posts: 7 Contributor I
    Hello @MarcoBarradas even in the case of joining the two datasets, what is a way to refer to / obtain the required rows? From my understanding, a Filter Examples operator can be used, but I'm not sure how to input a variable (akin to a row index or an ID) as the reference parameter to filter. Please feel free to let me know if I need to elaborate further because I currently am building a process and just seem to have encountered a similar problem. Thanks in advance!
  • Options
    sectynsectyn Member Posts: 25 Maven
    A Set Minus should work for this.
Sign In or Register to comment.