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

blatoo

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?

MartinLiebig

Hi,

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

Cheers,

Martin

blatoo

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