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

Alteryx
Alteryx
Created

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


Cause


Region or NLS_LANG conflicts.



Resolution


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