If empty then xx. (Error: Parse Error at char(0): Parse Error (Expression #1)

[Barclaysusercds]

I want to write a basis formula if a column in this case [Concat] is blank or empty then put "Other derivative" otherwise [Concat].

How do I write this in Alteryx?

I tried writing these two formulae in the box but an error message appears.

=if(!IsEmpty([Concat]), "Other derivative",[1 - DataLens matched])

=IF [Concat]="" THEN "Other derivative" ELSE [Concat] ENDIF

[binuacs]

@Barclaysusercds can you try the below formula

IIF(IsEmpty(Trim([concat]),'Other derivative',[concat])

[IraWatt · Accepted solution]

Hey @Barclaysusercds,

You bottom statement looks fine after removing the equals sign:

Make sure your data is of type string 

[messi007]

Hello,

Please see below how you can do it

if IsEmpty([Concat]) THEN  "Other derivative" ELSE [Concat] ENDIF

iif(!IsEmpty([Concat]), "Other derivative",[Concat])

Hope this helps!

Regards 

[IraWatt]

@Barclaysusercds your issue is the "=" only need to do that in Excel ;)