Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
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
16 Comments (16 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:
16 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
‎05-10-2024 04:21 PM
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
‎05-13-2024 03:15 AM

Released in 2024.1 thus can be closed.

0 Likes
Not applicable
‎06-04-2024 07:32 AM
Status changed to: Implemented
 
0 Likes
simonaubert_bd
13 - Pulsar
‎06-06-2024 04:12 AM

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

0 Likes
Labels