IF AND ELSE THEN statements - learning curve

Hello Alteryx community! New to SQL here... Scenario: some patients are on AntiPsychotic medications as well as non-AntiPsychotic medication. If a client is on Anti-Psychotic Medication I want the result to be "Client on Antipsychotic Medication" even if only 1 of their 10 medications is an AntiPsychotic... As well as if they are on no AntiPsychotics, I want it to be "Not on AntiPsychotic Medication"My first formula here works, but, the second one does not... What do you recommend?

Output

Accepted answers

FloraF

@MaryCann

Hi Mary,

I was able to get to what you are looking to accomplish, by doing the following. I would recommend 2 things though; first, of writing an IF statement, have the list of Antipsychotic Medications in another input. Second, for better performance, I would assign 0 for those patients who are not on Antipsychotic drugs and 1 for those who are on it, once all members/clients are assigned, I would rename the 0 and 1s. This will ensure better performance, especially as your list of clients will increase. I attached the workflow for your convenience as well.

**If this solves the issue, please click on the like below" thank you!

Assigning a value even if patient has other records.yxzp

All comments

IraWatt

One option which is easier then writing huge if statements is just to have a mapping table then joining it to your data. If it matches then use the mapped name for instance 'AntiPsychotic', if they don't map use the other name. I've attached an example below.