Issue with Column Expression

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.

Hello @Deano478,

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



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.