Multiple "IF" conditions

kmontoya

Hello, 

I have a set of data that needs to have filters and categorize it from excluded or included based on multiple things. Is there a way I can create a key or legend in alteryx to have this flow? 

For example, If

• "instrument type" = cashflow - "excluded"
• "exchange" = AVG or GTO = "Excluded"
• anything else needs to say included 

thank you in advance! 

Data example_.xlsx

patrick_digan

@kmontoya Try something along these lines:

 IF [instrument type] = "cashflow" or [exchange] in ("AVG","GTO") then "Excluded" else "Included" endif