"[solved]How can I filter a dataset after an attribute?"

blatooblatoo Member Posts: 32 Contributor II
edited June 2019 in Help
Hi all,

I have a big table, I want to select a part of them after an attribute, for example the attribute is "userId", I want select the records which userId = 5,6,9,20,...

I know, if the to selected userId list is not long, I can do it with "filter example" and set the "custom_filters" one by one. But if the userId list is huge, so I can not do it with "filter example"

For example, in the following table, I want select all the records, which userId = 1,3,9,20,...
userId time pr1 pr2
1 3-4 1 0
1 3-5 1 1
2 3-4 1 0
3 3-7 1 0
3 3-8 1 0
5 4-1 1 0
Do you know, how can I use rapidminer so deal with this problem?
Tagged:

Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,503 RM Data Scientist
    Hi,

    if you have a table with the wanted customer IDs, you can use a join to do this

    Cheers,

    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • blatooblatoo Member Posts: 32 Contributor II
    Martin Schmitz wrote:


    if you have a table with the wanted customer IDs, you can use a join to do this

    Hi Martin, thanks very much for this suggestion! It works!  ;D
Sign In or Register to comment.