Converting Excel Formula to Alteryx Formula

Question

Afternoon Team,

I am hoping you can help me.

I have created the below formula in excel, an i would like to replicate this logic within Alteryx

Column A1 :
Header : Building

Column B1 :
Header : Address

Formula : =IF(ISBLANK(B2),A2,IF(ISBLANK(A2),B2,CONCATENATE(A2," ",B2)))

Looking forward to your help

Regards
Masond3

atcodedog05 · Answer

Hi @Masond3

@Christina_H 's formula should work good in your scenario if you are looking for if-else approach here is a formula

IF IsEmpty([Address]) then [Building]

Elseif IsEmpty([Building]) then [Address]

Else  [Building]+" "+[Address]

EndIF

Hope this helps : )

Christina_H · Answer

trim([Building]+" "+[Address])

No need for the if statements in Alteryx, it can handle blank fields.  The trim function removes any leading/trailing spaces.