KNOWLEDGE BASE

Group built on a file joined to a relational data source triggers error 353FBC8D


Published: 03 Feb 2020
Last Modified Date: 28 Jul 2021

Issue

If a file is joined to a relational data source and a group is built on a field belonging to the file, building a view including the group and any measure triggers error 
Unable to complete action

No such table: [FQ_Temp_1]

Error Code: 353FBC8D

Environment

  • Tableau Desktop 2019.2 and later
  • Cross-database left and right joins between a file and a relational data source

Resolution

OPTION 1:
Upgrade to Tableau Desktop 2019.4.6, 2020.1.3 or later

OPTION 2:
Replace the group with a calculation similar to the one below:
Case [GroupingField]

when "key00" then "Grp1"
when "key01" then "Grp1"
when "key02" then "Grp1"
when "key03" then "Grp1"

when "key04" then "Grp2"
when "key05" then "Grp2"
when "key06" then "Grp2"
when "key07" then "Grp2"

when "key08" then "Grp3"
when "key09" then "Grp3"
when "key10" then "Grp3"
when "key11" then "Grp3"

...
else "GrpN"
END

OPTION 3:
Extract the data source

Cause

This is a known issue that is fixed in more recent version of Tableau Desktop.
Did this article resolve the issue?