Formula Question for multiple columns

[lac]

Hello,

Can someone please help me?  Trying to figure out a way in Alteryx to do this same thing this excel formula is doing.

I created a new column called "new category" (column e shown below). I'd like the string value in this column to populate what shows in column C UNLESS there is a value (not null) in column D. If there is a value in column d I want that to populate in E instead.  Thanks,

 

[Emil_Kos · Accepted solution]

Hi @lac,

I have created a workflow for you:

The formula is:

IIF([Where]='business office', 'business office', [level])

[Luke_C]

@lac 

Yes, you can use an IF statement in Alteryx. The syntax is a little different than excel though. I attached an example with two approaches based on your message. 

Using your screenshots as an example:

IF [Where] = 'business office' THEN [Where] ELSE [Level] ENDIF

Or, if it is simply anywhere where the 'where' field isn't null:

if !IsNull([Where]) then [Where] else [Level] endif

[Emil_Kos]

Hi @lac,

Actually, my previous workflow was incorrect. Please see an updated version

[lac]

You made this very easy. Thank you