KNOWLEDGE BASE

Error Code : 9EC30172: Cannot blend the secondary data source because one or more fields use the DATEPARSE function


Published: 24 Mar 2021
Last Modified Date: 24 Mar 2021

Issue

Error Code : 9EC30172: Cannot blend the secondary data source because one or more fields use the DATEPARSE function, which cannot be computed locally when using DateParse functions with aggregations like MAX, MIN,Count etc

Example: Calculation like the following with blend throws the above error: date(DATEPARSE("dd mm yyyy", MAX([Date string])))
User-added image

Environment

  • Tableau Desktop

Resolution

Use a replace function to replace the date as per required format 

Example :

Solution calculated field:
date(max(REPLACE([Date string]," ","/"))) to parse a string in the format like "20 01 2020"

User-added image

Cause

Blending has a limitation with Date parse being used with aggregation of the dimension
Did this article resolve the issue?