Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

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

Alteryx Alumni (Retired)

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