Creating multiple variables based on conditional statement

San_rise

I have an input data, wherein I need to create two new columns following a conditional statement.

Refer the condition below:

If call_date is not null and call_disposition is equal to 1 then New_variable1 = call_date and New_variable2 =1.

Please guide how can I achieve this result.

A step by step guide will be really appreciated since I am using alteryx for the first time.

Thanks in Advance

Joe_Lipski

Hi @San_rise 

Firstly, a huge welcome to Alteryx and to the wonderful community. Secondly and just an FYI you've posted in the Analytics Hub forum, the Designer Discussion board would be better suited for your request.

You will need to use a formula tool to create a new column and then you will want to use a formula similar to:

IF !ISNULL([call_date]) AND [call_desposition]=1 THEN [call_date] ELSE NULL() ENDIF

And you'll want a similar formula for your second variable.

Please let me know if this is what you was asking for?