2 Replies Latest reply on Jul 16, 2012 9:50 AM by hub.yoo

    GRIPE: How come a one to one data link doesnt work (Data blending)


      I love tableau. I hate certain things about it though.


      I linked two seperate data sources by creating a custom relationship. In my case it was base material linked to base material. It SHOULD show a link

      a - a

      b - b

      c - c

      However, when I put it on, i get a lot of * values. WHY? I dont get why 70% show the link and the rest are *. I thought it was for when there are multiple values linked



      Hello everyone,


      I was wondering if someone could help me with a data blending problem I am having.


      I have three data sources: Manfacturing Specs (Operations); InventoryByPartNumber (Inventory) and StockingLevels (Inventory). Normally I would join tables for the (inventory) data source but they do not have any linking fields. The stockingLevels (inventory) actually has a link by part number to Manufacturing Specs (operations), and there is a link between InventoryByPartNumber (Inventory) and Manufacturing Specs (operations) with the field of base material.


      I'm trying to connect Stockinglevels to manufacturing to inventory by partnumber but it seems like i can only manipulate two non-joined data sources at once. Is this correct?


      PS. Ive tried joining three tables within (inventory) but that gives me a different headache.


      Any help would be appreciated, thank you very much.

        • 1. Re: GRIPE: How come a one to one data link doesnt work (Data blending)
          Jonathan Drummey



          Tableau's data blending feature is a variation of a left join. Tableau issues a query to the primary data source, and a query to the secondary date source, then joins the two data sources on the linking fields while also aggregating fields from the secondary data source. The * you are seeing indicate that given the linking fields (the ones with the red/orange chain links in the Dimensions window), Tableau is returning multiple values for the chosen dimension. The  most common reason I've seen for that is that the aggregation is happening at an insufficient level of detail, so probably more linking fields need to be added to the view.


          As far as the second half of your message, it seems like you are trying to link source "a" to source "c" via source "b" using blending and I don't know any dynamic way to do that using blends. You can simultaneously blend "a" to "b", "a" to "c", "a" to "d", etc., but there is always one primary data source in a view that all blends occur off of. You can also use Tableau's primary groups feature to "push" data from a secondary source into the primary, but this is not dynamic and any time you added new values of the desired dimension(s) into the secondary you'd have to update the group.


          If at all possible, you're probably going to be better off doing as much of the joins as possible in the Tableau data source (using Multiple Tables or Custom SQL) or creating specific queries in the data source.



          • 2. Re: GRIPE: How come a one to one data link doesnt work (Data blending)

            Thank Johnathan for taking the time to respond. You're the 1538901398th person that reccomended custom SQL's so maybe that something I have to do/learn. Thank you very much