In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

If contains formula

sanastasova
7 - Meteor

The data source file  contains the new (2022) and old (2021) scorecards.

Workflow 1 works only for 2021, I need to change it to work for both 2021 and 2022. 

However to change there needs to be crated a new column only for the years. I am wondering why when typing the "if contains" formula it should be = -1 , in order to have a data preview of the year different from N/A.

sanastasova_1-1643788482468.png

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @sanastasova 

 

You can use formula like this.

 

atcodedog05_0-1643788884471.png

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @sanastasova 

Cheers and have a nice day!

sanastasova
7 - Meteor

Thanks a lot ! Have a nice day :) 

Labels
Top Solution Authors