1 Reply Latest reply on Mar 27, 2016 11:39 PM by Mahfooj Khan

    Why '*' showing In Filters

    hema latha

      Hi,

       

      While applying Show filters at Dashboard , in filters ' * ' Is showing. How to remove ' * '? [In that Null Values are there as well as Unknown Values also there ]

       

      I done Edit filter - and Exclude ' * ', still it is showing.

       

      I done data Blending with 3 databases.

       

      Please let me know with your suggestions.

        • 1. Re: Why '*' showing In Filters
          Mahfooj Khan

          Hi,

           

          Tableau's data blending, what Tableau does is issue two queries, one to the primary data source and one to the secondary. The query on the secondary is an aggregate query at the level of detail defined by the linking fields in the view that will only return one record per combination of the values of the linking fields, whereas a normal left join would return as many rows as were in the secondary that met the joining criteria. Once the data is returned inside Tableau, the secondary is "left joined" back to the primary.

          Here linking field is returning more then one record per combination of the values. That's why you're getting "*".

           

          Mahfooj