Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

formula

hi2019
8 - Asteroid

Hi,

 

 

if Contains([Keyword List2], "") then "CoPayee Containing SS_ACC" else flag endif

 

Is this correct formula to pull out all the ones that have a keyword list? I am trying to pull out in a seperate tab if the keyword list is found by naming it that

 

 

thanks 

 

currently what I have but it is not labeling them"CoPayee Containing SS_ACC" - it is not showing any 

 

 

1 REPLY 1
cjaneczko
13 - Pulsar

The way you have it written now you are looking for blanks in the Keyword list column. If there are any blanks then replace the blanks with "CoPayee Containing SS_ACC". Your flag needs to be surrounded by a quote for the formula to replace the field with "flag" when there are no blanks. 

Labels
Top Solution Authors