The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Ideas

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

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

Submission Guidelines

Coalesce function

Status: Implemented Submitted by on ‎10-31-2021 07:50 AM
14 Comments (14 New)

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
See more ideas labeled with:
14 Comments
NicoleJ
Alteryx
Alteryx
‎03-22-2024 01:41 PM
Status changed to: Coming Soon

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

0 Likes
Not applicable
‎03-27-2024 03:50 PM
Status changed to: Coming Soon
 
0 Likes
NicoleJ
Alteryx
Alteryx
2 weeks ago
Status changed to: Implemented

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
Alteryx
Alteryx
a week ago

Released in 2024.1 thus can be closed.

0 Likes
Labels