Error: Parse Error at char(0): Empty expression (Expression #n)

[Alteryx_KB]

Environment Details

Error: Parse Error at char(0): Empty expression (Expression #n)
 

• Alteryx Designer
  • All versions
• Formula Tool
• Multi-Row Formula Tool
• Multi-Field Formula Tool

Cause

The tool is attempting to execute a missing or empty formula.

Resolution

Breaking down the error message below in the Formula tool, Parse Error at char (0) tells you exactly where the issue is: remembering that Alteryx Designer is 0-based, the error occurs at the zeroth character, i.e. the very beginning of (Expression #1), which is empty in this case. 


The Multi-Row Formula tool also identifies the character position, and only uses one expression at a time, so it does not need to identify an expression number. 


To resolve, please enter a formula or function .