Options

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

JKLONDONJKLONDON Member Posts: 3 Contributor I
edited June 2019 in Help
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
Tagged:

Answers

  • Options
    earmijoearmijo Member Posts: 270 Unicorn
    The operator is "Filter Examples".

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

    In "Parameter String" write:

    A > 0 && B = ABC
Sign In or Register to comment.