Operator to "Where not in " clause

morrgray

Hi, I am looking for a operator that can perform " where not in  ". I have two data sets I want to have rows from first data set which not contain in the seond data set by compare two date columns like :

select * from dataset1

where  dataset1.date not in (select date from dataset2)

How can I do it in Rapidminer? 

Thanks in advance

kypexin

Hi @morrgray

 

It's 'Set Minus' operator which should do the trick, it returns those examples of the ExampleSet whose IDs are not contained within the other ExampleSet. But also note that before applying it you also have to use "Set Role" operator on both datasets and convert those date fields into 'id' type.