Alteryx Column building from excel

[Tonytran2014]

Hi everyone, I am rather new to Alteryx and I am working on trying to create columns based off of excel columns that have formulas dedicated and referencing even more cells.

For example how would I create that formula in alteryx

[Felipe_Ribeir0]

Hi @Tonytran2014 

You need to use the formula tool, the formula for this is IF [DO2] = 0 THEN "-" ELSE [DO2] - [DN2] ENDIF. Notice that using Alteryx you will reference the column names of your input, not the cells like with excel. take a look at the attached workflow

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[CathyS_Slalom]

Hi @Tonytran2014, you can use the tool, "Formula" under "Preparation" section to create a new column with a similar formula. You can learn some of basic formulas by clicking the open examples.

 I can also build an example, would you mind to share a sample data? 

[Emmanuel_G]

@Tonytran2014 

Find in attachement the way of doing that.

The IIF function in alteryx works exactly as in excel according the syntax : IIF(your_test,value_if_true,value_if_false).

I did a test with dummy dataset.

[Felipe_Ribeir0]

Hi @Tonytran2014 

It worked?