KNOWLEDGE BASE

Asterisks Appear in Views with Blended Data


Published: 02 Sep 2016
Last Modified Date: 26 Oct 2016

Issue

When blending data, and creating views in which fields or filters are brought in from a secondary data source causes asterisks to appear in views. ("*")

Environment

  • Tableau Desktop 10.0.0
  • Blended Data

Resolution

With Tableau Desktop 10 it is now possible to do cross-database joins. Join the data instead of blending it:
  1. Connect Tableau Desktop 10 to the data source that contains the field which is generating asterisks.
  2. Create a new connection to your secondary data source and drag its table into the connection pane where you have the primary data source.
  3. Define the join operator, recommended to be joined on the most granular matching field.
  4. Left join is recommended
  5. Re-create the view with the joined data, asterisks should no longer be there.

For versions prior to 10:
  • If there is no possible relationship to define between the two blended data sources for fields causing asterisks, consider placing all of the blended data tables into the same database in order to join them.
  • If it is possible to define a relationship between the two blended data sources for fields causing asterisks, follow the "Asterisks show in the sheet" section of the Troubleshoot Data Blending product help guide.
Did this article resolve the issue?