Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

Filtering Data

Highlighted
5 - Atom

Hello,

 

New to Alteryx here. 

 

I am trying to filter out by State. In my particular case, i am trying to separate 5 Mexican states from the rest of the states.

Jalisco, Tamaulipas, Ciudad de Mexico, Estado de Mexico, and San Luis Potosi

 

I have tried basic filters and custom filters. The basic filter with commas did nothing and the custom filters keep giving me errors.

 

Thanks

Highlighted
11 - Bolide

 

[State]='Jalisco' OR [State]='Tamaulipas' OR [State]='Ciudad de Mexico' OR [State]='Estado de Mexico' OR [State]='San Luis Potosi'
 

 

 

Hi @stewartlewis , would the above condition in a filter tool get you what you're looking for?

Highlighted
16 - Nebula

Perhaps you can use a custom filter statement such as

 

[state] IN ("Jalisco", "Tamaulipas", "Ciudad de Mexico", "Estado de Mexico", "San Luis Potosi")

 

also check in some of your states have leading or trailing white space

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @stewartlewis, setup your custom filter logic using something like the following string:

 

[STATE] IN ('Jalisco', 'Tamaulipas', 'Ciudad de Mexico', 'Estado de Mexico', 'San Luis Potosi')

 

Let us know if you still get an error.

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @stewartlewis ,

 

you can use also the custom filter as below.

 

 

State in ('Jalisco', 'Tamaulipas', 'Ciudad de Mexico', 'Estado de Mexico', 'San Luis Potosi')

 

Best,

Fernando V.

 

Highlighted
Alteryx Certified Partner

Hi @stewartlewis ,

 

Use a filter tool and use the following formula (Letters for simplicity):

 

[State] IN ("A","B","C")

 

mceleavey_0-1586362806887.png

The "T" or "True" output will have the states you want, the others will be in the "F" or "False" output.

 

M.

Highlighted
5 - Atom

It looks like that is going to work. I was forgetting the apostrophes (not sure if there is another term used). I will run it with that formula and see what I get back. Thank you so much for the quick reply.

Labels