Function similar to "Coalesce"

[kmcdowell]

Hello,

I am trying to find the best way to choose the first non-null variable for output from a list of variables.  This is similar to the coalesce function in sql or SAS. So, if there are five fields, I would like to output the first one in the list that is not null.  If all are null, then it would just output the last field.  Any ideas would be appreciated.  Thank you!

[Prometheus]

Thanks. I was able to get part of the logic down through your pictures, but when I downloaded the file, I saw there were no tools in it.

[simonaubert_bd]

Hello,

You can vote for this idea
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Coalesce-function/idc-p/850922#M16449