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

Excel's #N/As read as zeros! UNACCEPTABLE!

The excel driver (.xlsx) converts these values to 0.  If you use the legacy excel driver (.xlsx) it brings in the #N/A values.  This issue was reported in the community and I am forwarding it to the New Idea as a problem that needs to be addressed on behalf of @JohnDoe.

11 Comments
JohnDoe
8 - Asteroid

Actually, I have noticed that, after the 10.1 update, these excel errors are imported as nulls if the column has other records with numerical values, but are imported as text (the text "#N/A", etc. if they are in a column where other records are text strings!