How to filter Multiple data

[Gsiva3]

Hi Team,

I have a input file with columns namely A & B. Column A contains row values as 21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43.

My desired output is, I want row values from column A along with column B which has only 26,38,42.

I have attached the sample input & desired output.

Please help me on this.

[atcodedog05 · Accepted solution]

Hi @Gsiva3 

You can use the filter tool like below.

Workflow:

Hope this helps : )

[messi007 · Accepted solution]

@Gsiva3,

Please see below :

Attached the workflow,

Regards

[DawnDuong]

hi @Gsiva3 

The solutions suggested by @atcodedog05  and @messi007  are the most straightforward and efficient for the specific use case where the operands are fixed. 

Note though that IN operator requires that you input field (i.e. column A in this case) is of the same general data type as the conditions. If column A is a string type, then the test value needs to be enclosed in quotes e.g. [Column A] in ('26', '38', '42').

On the other hand, if column A is a numeric type then the test value must not be enclosed in quotes e.g. [Column A] in (26, 38, 42). If the type is mismatched, Alteryx will throw out "type cast" error.

The following page is very helpful in explaining how to use the various operators (including the IN operator) in Alteryx:

https://help.alteryx.com/20213/designer/operators

Dawn.