Creating a new Column (very new to Alteryx)

[bdoorly]

How do I create a new column in Alteryx ?  For starters - Which icon/tool do I use ? (I am very new to Alteryx)

I want to create a new column with the value being based off

IF "Existing Column" = "x", then "New Column" = y  

Thanks !

[PhilipMannering · Accepted solution]

Hey @bdoorly 

You would want to use the Formula Tool with the expression,

This should work.

Thanks

Phil

[atcodedog05]

Hi @bdoorly 

as @PhilipMannering mentioned you need a formula Tool for this task

The tool which is like a flask.

Its under preparation palette.

Here is some resources to go along with it and understand it.

https://community.alteryx.com/t5/Interactive-Lessons/Writing-Conditional-Statements/ta-p/98910

If you are new to alteryx i would definitely suggest you to take up this learning path designed for beginners.

https://community.alteryx.com/t5/Learning-Paths/tkb-p/learning-path

Hope this helps 🙂

Cheers, Happy Learning and Analyzing 😀

[marcusblackhill]

Hi @bdoorly 

In addition to @PhilipMannering , answering your question, is the tool in the print below:

Other way to you find any tool in alteryx is using the search tool in the top right of the screen:

Hope that help!

[bdoorly]

Thanks - solution worked !