SPLIT and UNION
Tuesday, February 22, 2011
3:12 PM
Splitting a dataset into subsets
SPLIT <relation> into <relation2> if <expression2>, <relation3> if <expression3>, …;
Equivalent with multiple FILTER-BY statements. 
Example
SPLIT employees into salaried if salary>0, unsalaried if salary==0; 
Putting together split relations
<relation> = UNION <relation2>, <relation3>, …; 
Example: 
stuff = UNION salaried, unsalaried; 