Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

contain formula

Highlighted
8 - Asteroid

hi,

 

i have issue when i use contain formula for it, i tried to filter these contains([stage],"closed") deals, but somehow the result come out never include item 1 and 2. can you coach me on how to do this filter formula?

  1. 5-closed/won
  2. closed/lost
  3. closed
Highlighted
Alteryx
Alteryx

Hi @lilyyangadsk

 

That appears to work for me. The contains functions returns a 0 when false and a -1 if it is true. 

 

Are you able to show you results window with the above function in the formula?

 

Here is mine:

 

Contains.png

Highlighted
8 - Asteroid

thank you , it works.

Highlighted
Alteryx
Alteryx

You're welcome. If you use it in a filter tool it should split the data to the true and false how you require as well.

Labels