community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

An IfError Function

I was just thinking how nice it would be to have an IfError function like there is in Excel.  With Alteryx's design, there isn't really much need for the function.  I just ran into a case today where I thought it might be useful.  There was a function created after a crosstab that expected certain field names to exist.  I got around this by using filter, summarize, and join tools instead. 

 

It just stuck with me that it would be much easier to just say:

 

IfError([FieldThatDoesNotExist],0)

Something like this could also be used when referencing a field which has a calculation that produces an error.

 

I don't know if something like this would be completely antithetical to Alteryx's design, but there are times when it would definitely be convenient. 

1 Comment
Meteor

@MichaelMains Agree.

 

Ran into situation where data was not available and a divide by zero error occurred.

It would be nice to have blank space read as NA.