Replacing blank values with values from another table

[Truffler]

I would like to create a column where if the value in column z is blank, it replaces it with the value in column y. If column y is blank then the value from column x is used.

Any ideas how to do this?

[dplr-rn]

what does your undelying data look like.

options depends on that

[mfarsln]

Hi,

If your columns are comes from same table or associated by key column, then you can use below expression to create a new column.

if(
len(if(len(z)=0,y,z))=0,x,if(len(z)=0,y,z)
)