IF statement Concatenate

[mpotstada]

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 solution]

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,

[mpotstada]

Thank you, very helpful.