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

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