"How can I create a subset based on filtering criteria"

JKLONDON

Sure this is easy but cant find the answer. I have a data set X with 1MM rows and 20 columns. I want to create Y, where Y is a subset of X, filtering on columns A and B. The filter rule would be only include row in Y if  A > 0  AND B = "ABC" (for example).

What operator can I use to do this?

Thanks very much
JK

earmijo

The operator is "Filter Examples".

In "Condition Class" select "Attribute Value Filter".

In "Parameter String" write:

A > 0 && B = ABC