KNOWLEDGE BASE

Error: "An error occurred when communicating with data source <data source name>. Tableau Data Engine Error: 4 no such function (>= integer string)" When Selecting a Parameter Option


Published: 27 Apr 2015
Last Modified Date: 02 Nov 2017

Issue

When switching to a published data source that includes a calculated field using IF or CASE logic with a parameter, the following error message might occur:
An error occurred when communicating with data source <data source name> 
Tableau Data Engine Error: 4 no such function (>= integer string)

Environment

  • Tableau Desktop
  • Published Data Source

Resolution

Ensure the offending IF/CASE calculation has a default option included (i.e. it must end with an ELSE clause). If it is a nested IF/CASE, ensure all levels have that ELSE clause. The ELSE clause needs to be included even if it will never be reached and only returns a NULL.

Cause

In our current design, IF/ELSE statements that use parameters need to have an explicit condition to fall back on in order to generate the correct query.
Did this article resolve the issue?