A very useful and common functionhttps://www.w3schools.com/sql/func_sqlserver_coalesce.asp
Return the first non-null value in a list:
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!
Thank you for your suggestion, @simonaubert_bd !
a coalesce function would be so useful, i regularly need to merge columns with 6 or 7 nested ifs..
I'd love to see more functions like these.
Simple et efficace, bonne idée
I think this would be a good addition to Alteryx. Right now, the only other way to get columns in priority order and ignoring nulls is by a complicated set of IF statements that only get longer the more values are added in.
I'd also like an Alteryx feature where you can specifically mention a column's name in a formula (for example, if a column was XY, having a formula where you can get the value of whatever column has the name "X" + "Y"), but I get if that's more complex.
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.
Stay tuned, coming soon to a Designer release near you! 😁
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!
Released in 2024.1 thus can be closed.
Hey @NicoleJ Thanks. Will change life when writing formula.
