formula
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
And if 'OTH' is entered in column [SerImpacted] then what should [OtherSerImpact] be?
Do you have an input and expected output you can share?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If it is not OTH in Serimpacted it should be blank in OtherSerImpact
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
And what if it is OTH in Serimpacted? What should OtherSerImpact be then?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Radiology
RT Therapy
Sleep
MSK Management
Oncology
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Have you got a sample of the data you can share?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I believe the syntax would be:
if [ServicesImpacted] not in ('OTH') and !isnull([ServicesImpacted])
then 'other services error' else Null() endif
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you!