Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

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
5 Comments
kelly_gilbert
13 - Pulsar

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 Alumni (Retired)

Thank you for your suggestion, @simonaubert_bd !

Matthew
11 - Bolide

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

Thableaus
17 - Castor
17 - Castor

I'd love to see more functions like these.

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes