Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Numeric values show "[Null]" instead of a blank cell using the Input Data tool


Environment Details

The Input Data or Connect In-DB tool will populate numeric values with "[Null]" instead of a blank cell. Querying with other tools such as SQL Developer show blank cells.

idea Skyscrapers

  • Alteryx Designer
    • All versions
  • Oracle
    • 12c+
  • Oracle ODBC
    • Driver version 12.02
  • Langue/Region Settings


Region or NLS_LANG conflicts.


In the ODBC DSN configuration page for the Oracle ODBC driver used for the connection in Designer, select the option "Use Microsoft regional settings" for the Numeric Settings option. Recreate the Input or In-DB connection and re-test.

idea Skyscrapers