Coalesce function

[simonaubert_bd]

A very useful and common function
https://www.w3schools.com/sql/func_sqlserver_coalesce.asp

Return the first non-null value in a list:

COALESCE(NULL, NULL, NULL, 'W3Schools.com', NULL, 'Example.com')

returns 'W3Schools.com'

It exits in SQL, Qlik Sense, etc...

Best regards,

Simon

[NicoleJ]

Stay tuned, coming soon to a Designer release near you! 😁

[NicoleJ]

Excited for the addition of the Coalesce function in 24.1 release! Check out this new function (and all the other 24.1 goodies) in our Designer release notes! Happy Alteryx-ing!

[AlteryxIdeasTeam]

Released in 2024.1 thus can be closed.

[simonaubert_bd]

Hey @NicoleJ  Thanks. Will change life when writing formula.