Azure Data Factory - Data Flow - Concat Columns

Question

Hi,

I am trying to concatenate two string columns in Data Flow in Azure Data Factory. I am making sure I will not have any nulls using this expression in Derived Column

iif(isNull(LEASE_ID),'\n',LEASE_ID)+iif(isNull(LEASE_TYPE),'\n',LEASE_TYPE)

But I am still getting this error

I have tried almost everything to concat these columns, but I am still getting error. I need to make sure it will work for all columns, as used columns will be defined by parameters.

Do you know what I can do?

Answer 1

Try: iifNull(LEASE_ID,'\n',LEASE_ID)+iifNull(LEASE_TYPE,'\n',LEASE_TYPE)