IF statement Concatenate

Question

Hi,

I am new to Alteryx and trying to do something that seems so simple from an excel perspective.  I am trying to replicate the formula below in Alteryx.  I attempted this with the formula tool but I am clearly missing something.  Any help would be appreciated.

Excel formula:

Color 1  Color 2  Color 3  Color 4  Output

Red        Blue       Orange Pink       RedBluePink

Red        Blue       Green   Pink       Green

Color 1  Color 2  Color 3  Color 4  Output

Red        Blue       Orange Pink       =IF(C2="Green",C2,A2&B2&D2)

Red        Blue       Green   Pink       =IF(C3="Green",C3,A3&B3&D3)

Thableaus · Accepted Answer

Hi @mpotstada

Add a Formula Tool.

Create a new column - Color 4

IF [Color 3] != "Green" THEN

[Color 1] + [Color 2] + [Color 3]

ELSE [Color 3] ENDIF

Cheers,