Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to build Search formula with specific conditions

Learner09
8 - Asteroid

I am trying to add new column credit in my analysis. 

 

Below is the excel formula that I am trying to build in Alertyx.

 

=IF(ISNUMBER(SEARCH("*credit*",BE3)),"Yes","No")

 

Please see the attached example file and assist me 

3 REPLIES 3
Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @Learner09 ,

 

Here is an example workflow using the function Contains to check the presence of the value "credit" into your column.

 

Cheers,

 

Jean-Baptiste

Learner09
8 - Asteroid

Thanks, Jean, you are superstar 🙂

Jean-Balteryx
16 - Nebula
16 - Nebula

Thank you @Learner09 , that's nice. I wish I was 🙂

 

Cheers,

 

Jean-Baptiste

Labels