Help requested for Drop Down List filter

N_87

Hi everyone, my apologies if this is a silly question (beginner to Alteryx here and have tried various solutions in community but am not able to get my workflow to work)

My intent is to filter a data set with 2 criteria based on user selected values in a pre-populated drop down list:

If User selects "Cornelius" , output file will only contain records with "Cornelius" values under Current Partner column and all other values that are not "Cornelius" under Original Partner column.

For the Action tool, I am currently selecting the Operand -value- setting.

When I run the workflow my output file contains zero records, the expected results should be 2 rows of data when "Cornelius" is selected.

I have a feeling that the problem lies in the configuration of the Action tool, could someone please guide me along please?

Thank you for your time!

Basic Dropdown filter.yxzp

BenMoss

The answer @jamielaird has provided is partially, but not completley correct.

When you use an action tool on a filter tool there are two areas to change, one area relates to the 'custom filter' mode, and the second relates to the 'simple filter' mode, if you choose the incorrect one, then the filter will not apply as expected.

I have shown which is which in the diagram (blue being simple, red being custom).

Therefor we need to change the 'expression' (because you are using the custom filter mode) and then use Jamies advice to only replace a specific string, as in the image below.

Ben