How to put two condition in filter

[Neeta_Latwal]

Hello Community,

I try to find a solution to validate below, how to below two login in one filter tool  :-

Column A contain "Pair off"

Column B: length greater than 7 

Thanks,

Neeta

[p-g]

To create a filter in Alteryx Designer that validates both conditions (Column A contains "Pair off" and Column B has a length greater than 7), you can use the Filter tool with a custom expression. Here's how you can do it:

1. Add the Filter Tool: Drag the Filter tool onto the canvas and connect it to your data stream.

2. Configure the Filter Tool:

   • In the Basic Filter tab, switch to the Custom Filter option.
   • Enter the following expression:
     
     Contains([Column A], "Pair off") AND Length([Column B]) > 7

This expression checks if "Pair off" is present in Column A and if the length of the string in Column B is greater than 7.

3. Run the Workflow: After setting up the filter, run the workflow to see the results.

This should filter your data based on the specified conditions. If you have any more questions or need further assistance, feel free to ask!