Issue with Column Expression

[Deano478]

Hi all,

I have created the expression below but I feel my syntax is wrong as everything is evaluating to blank even though it shouldn’t be.

if (!isMissing(column(“Last Name”))) {
join(column(“First Name”), ’ ',column(“Middle Name”))
} else {
" "
}

Any help would be much appreciated.

[ipazin]

Hello @Deano478,

your expression works for me. Do you have red question marks in column Last Name?

Br,
Ivan

[takbb]

Hi @Deano478, if it’s still not working, I would suggest that you share a sample of data in case there is something that is being overlooked.