Conditional Statement with "Contains" or Starts With Instead of "="

[alphabex18]

Hi there all, 

Is it possible to write a conditional statement within the same column that uses a "Contains", "Starts with", "Does not Include" instead of just equals or does not equal?

here is what i would like to happen

IF [Queue Name] Contains (or starts with) "+1" THEN "External Call"
ELSEIF [Queue Name] Is NULL THEN "Undetermined Call"
ELSE "Internal Call" 
ENDIF

If not possible, i know that i can try to use a filter tool to separate them out to additional columns, but i am trying to avoid that 

Thanks so much

[MarqueeCrew]

Absolutely!

IF Contains([Queue Name], "+1")  THEN "External Call"
ELSEIF IsNull([Queue Name]) THEN "Undetermined Call"
Else "Internal Call"
Endif

Cheers,

Mark

[alphabex18]

I appreciate the quick response, however, all the results display "Internal Call" regardless of the type. 

FYI - currently the data type selection is V_String, which i changed at the beginning of the workflow from  "Double" (the field contains names or phone numbers). maybe that plays a part in why its not running as expected. 

[MarqueeCrew · Accepted solution]

please show a screen print of you formula configuration.

OUTPUT COLUMN = ?

Data Type = ?

I tried this and got good results.

Cheers,

Mark

[alphabex18]

it worked. I had to arrange the tool so it came before another formula tool. I think the data types got jumbled along the way. Thank you so much. Still learning IF statements in Alteryx, they can be tricky.