Converting Excel Formula to Alteryx Formula

[Masond3]

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 

[Christina_H]

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

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

[atcodedog05]

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 : )