formula

[VeronicaElse]

Hi, 

I am needing it to say 

for column OtherSerImpact  should be blank UNLESS OTH is entered in column SerImpacted

Thanks!

[PhilipMannering]

And if 'OTH' is entered in column [SerImpacted] then what should [OtherSerImpact] be?

Do you have an input and expected output you can share?

[VeronicaElse]

If it is not OTH in Serimpacted it should be blank in OtherSerImpact

[PhilipMannering]

And what if it is OTH in Serimpacted? What should OtherSerImpact be then?

[VeronicaElse]

Radiology
RT Therapy
Sleep
MSK Management

Oncology

[PhilipMannering]

Have you got a sample of the data you can share?

[mutama]

Hi @VeronicaElse ,

Using the Contains() function with Alteryx's Formula tool may help you with this (see here for more info: https://help.alteryx.com/20213/designer/string-functions).

Is the below what you're looking for? 

Please see sample workflow as attached, for your reference. 

Best,

MU

[VeronicaElse]

Hi, 

I think I said it wrong-I need it to read if the column servimpacted is not OTH and the other column otherservimpacted is also not null I wanted it to give off an error. Sorry, I am new to this position, so I am sure my formula written is not correct. Plz help!

if [ServicesImpacted] not in ('OTH') and [OtherServicesImpacted] not in Null()
then 'other services error' else Null() endif

thanks!

[nduan · Accepted solution]

Hi @VeronicaElse 

I believe the syntax would be:

if [ServicesImpacted] not in ('OTH') and !isnull([ServicesImpacted])
then 'other services error' else Null() endif

[VeronicaElse]

Thank you!