if contains elseif troubleshoot

hello,

I'm having a slight issue with my expression. can someone please help.

alteryx test 2.png

so basically I input the formula tool. And what I planned to have was ' change of bo', 'change of ppo', 'constitutional doc - ownership proof' and 'constitutional doc - ownership proof (cosima)' to have the field [Team2] to be autofilled a text "to check" and the rest as "not asc". however when I ran the workflow, all of the rows in [Team2] were filled as 'not asc'.

alteryx couldn't pick up any error within the expression, so I'm just curious as to what went wrong.

Regards,

Lance

Tips and Tricks

Accepted answers

cmcclellan

There's nothing obviously wrong with what you've posted, but what does the Input data look like ? Does it match the exact CaSe That You have SpeCiFied ?

All comments

patrick_mcauliffe

@lancegoh1I would try switching the order of your last two conditions.

lancegoh1

hi Patrick, I tried to put only 1 condition but expression is still filling the entire field with 'not asc' as shown below.

alteryx test.png

alteryx test 2.png

Regards,

lance

Surendar28

Can u able to share the input!

Regards

Surendar.C

cmcclellan

There's nothing obviously wrong with what you've posted, but what does the Input data look like ? Does it match the exact CaSe That You have SpeCiFied ?

harikakummara

Hi Lance,

It may be due to "Space" or "text match" issue. For text match issue, try using "Uppercase" function on column "[Doc Code (pre-1P)]" . For "Space" issue, try removing extra white spaces or copy exact text from [Team 2] column.

Either ways, it would be better if you can provide a sample of data here.

Thanks,

Harika Kummara

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703