Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Coalesce function

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
2 Comments
kelly_gilbert
12 - Quasar

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
Alteryx Community Team
Alteryx Community Team

Thank you for your suggestion, @simonaubert_bd !