Parse error and Missing error in Alteryx Sandbox

Sarath27

Hi All,

In summarize tool, all the required columns was present and it works well in Alteryx designer.

But when I run it in Alteryx Sandbox(Server), it throws an error.

• The field "irpnl" is missing. Compare the tool configuration with the input stream. {Action=Sum). (ToolId: 972)
• Parse Error at char(1): Unknown variable "Sum_irpnl" (Expression #2) (ToolId: 365)
• Parse Error at char(20): Unknown variable "Sum_irpnl" (Expression #5) (ToolId: 365)
• Parse Error at char(1): Unknown variable "Total P&L from Plex (£)" (Expression #6) (ToolId: 365)

Yoshiro_Fujimori

Hi @Sarath27 ,

The first message says the input data is lacking a field which is configured in Summary tool.

I cannot tell the cause for sure, but if it works on Designer but doesn't on Server, I would check if the input data is the same.

Does the Server access to the same input data as the PC you run your Designer?