KNOWLEDGE BASE

Error "[DataDirect](...)Syntax error in SQL statement at or about..." Using COUNTD of Concatenated String with Progress OpenEdge


Published: 23 Oct 2017
Last Modified Date: 23 Oct 2017

Issue

When trying to calculate the distinct count of a concatenated string from Progress OpenEdge, the following error occurs:

[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about...

Environment

  • Tableau Desktop 
  • Progress OpenEdge

Resolution

Option 1:

  1. Navigate to the data source tab.
  2. Use 'Data' > 'Convert to custom SQL'
  3. Add a line to the custom SQL for the string concatenation.
  4. Use Distinct Count aggregation on custom SQL concatenated field instead.

Option 2:

Perform the concatenation on a view directly in Progress OpenEdge and connect to the view.

Cause

Progress OpenEdge does not allow calculating the distinct count of a concatenated field. 
Querying directly against the database results in the same error.
Did this article resolve the issue?