Adding Value to a new column based on values in two other columns

Question

I am trying to think of a way to assign a value based on two other columns.  See below.  This site is great.  Thank you in advance for your help

PartnerCategory Product CodeNorthWinter RedSouthSummer YellowEastSummer MagentaNorthSummer OrangeSouthFall VioletEastFall WhiteNorthWinter RedWestFall PurpleSouthSummer YellowEastSummer MagentaSouthSpring PinkWestFall PurpleNorthSpring Blue        If Partner=North and Category =Winter then Product Code = RedIf Partner=North and Category =Summer then Product Code = Orangeetc…...

binu_acs · Answer

@amorej One way of doing this with the If Else condition

Column_Check_2508.yxmd

DataNath · Answer

Hey @amorej, you were just about there with what you had typed out! You first need to bring a Formula tool into your data stream and give the new expression a name (or you can edit an existing one), from the pane under 'Output Column'. There's just a few key tweaks to format the expression as needed for Alteryx:

1 - Wrap field names in square brackets e.g. Partner ought to be [Partner]

2 - The values that you are checking for (North, South, Summer, Winter etc) need to be within quotes, so [Partner] = "Winter" or [Partner] = 'Winter' for example. If you're checking numeric fields then you don't use quotes, would just be the number itself like [Total] = 100

3 - If there are multiple possible outcomes (i.e. a large list of Partner/Category combinations), then you use 'elseif' to essentially restart your if statement each time

4 - To finalise your if statement, you need to provide an 'else' which is essentially saying 'if my values don't match any of the combinations to output the outcomes I've listed above, just do this...' (in my example this is 'White', which is applied to everything where the values don't match a specific combination I've set out)

5 - Use 'endif' to actually finish your if statement

More great resources here if you want to learn more about expressions in Alteryx: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/writing%20expressions?labels=writing+expressions

Assign Product Code from 2 fields.yxmd