Replacing Null values in Column with string values

Hello,

I want to put Yes to 'Yes/No' column if either of 1st, 2nd or 3rd payer contains MCR or MEDCR otherwise No. I'm trying to do this with Filter tool but it's not working for me. Please suggest how I can achieve the result as I'm new to Alteryx.

Thanks,

Amit

MIPS.xlsx

Developer

Developer Tools

Input

Output

Macros

Common Use Cases

Best Practices

Accepted answers

AngelosPachis

Hi @amitsingh88 ,

You can do this with a formula tool, using the following expression

IF (Contains([1st Payer], "MCR") OR Contains([1st Payer], "MEDCR")) OR 
(Contains([2nd Payer], "MCR") OR Contains([2nd Payer], "MEDCR")) OR
(Contains([3rd Payer], "MCR") OR Contains([3rd Payer], "MEDCR")) THEN "Yes"
ELSE "No"
ENDIF

Regards,

Angelos

example.yxmd

All comments

apathetichell

Hi!

Try the formula tool. Filter tool separates records in your datastream.

So to filter out records with a null() you'd write:

isempty([1st payer])

And you don't even need the "IF" part...'

For formula make sure you are setting up your new column ("yes/no") as a string. Also - I personally have minimal experience using a "/" in a field name but could see it leading to problems...

AngelosPachis

Hi @amitsingh88 ,

You can do this with a formula tool, using the following expression

IF (Contains([1st Payer], "MCR") OR Contains([1st Payer], "MEDCR")) OR 
(Contains([2nd Payer], "MCR") OR Contains([2nd Payer], "MEDCR")) OR
(Contains([3rd Payer], "MCR") OR Contains([3rd Payer], "MEDCR")) THEN "Yes"
ELSE "No"
ENDIF

Regards,

Angelos

example.yxmd

amitsingh88

It is not working

I want result like this, if any of the 1st, 2nd or 3rd payer contains MCR or MEDCR then there should be Yes in Yes/No column otherwise it will be No.

Thanks

amitsingh88

Thanks @AngelosPachis . That will work.😊

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703