Hi,
I am needing it to say
for column OtherSerImpact should be blank UNLESS OTH is entered in column SerImpacted
Thanks!
Solved! Go to Solution.
And if 'OTH' is entered in column [SerImpacted] then what should [OtherSerImpact] be?
Do you have an input and expected output you can share?
If it is not OTH in Serimpacted it should be blank in OtherSerImpact
And what if it is OTH in Serimpacted? What should OtherSerImpact be then?
Radiology
RT Therapy
Sleep
MSK Management
Oncology
Have you got a sample of the data you can share?
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
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!
I believe the syntax would be:
if [ServicesImpacted] not in ('OTH') and !isnull([ServicesImpacted])
then 'other services error' else Null() endif
Thank you!