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

[kelly_gilbert]

Yes, please! Or, at least an IFNULL function (if argument 1 is null, return argument 2)

I find my self using IIF(ISNULL([field1]), [field2], [field1]) all of the time, so COALESCE or IFNULL would be a big time saver!

[CristonS]

Thank you for your suggestion, @simonaubert_bd !

[Matthew]

a coalesce function would be so useful, i regularly need to merge columns with 6 or 7 nested ifs.. 

[Thableaus]

I'd love to see more functions like these.

[Dewey]

Yes please this is a pretty common use case in SQL and come across it often in the course of Alteryx as well. Nested IFs can accomplish the same but it's an inelegant solution and gets very difficult to read when you get additional fields vs. the COALESCE(col1,col2,col3,...) syntax.

[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!