2 Replies Latest reply on Nov 17, 2016 9:54 AM by Robert Abarbanel

    Association Tables

    Robert Abarbanel

      I have a public v2 Odata source available to all. (http://services.odata.org/OData/OData.svc/ ).

      The "contents" includes

       

      <collection href="Products">

       

       

      <atom:title>Products</atom:title>

       

      </collection>

       

      <collection href="ProductDetails">

       

       

      <atom:title>ProductDetails</atom:title>

       

      </collection>

       

      <collection href="Categories">

       

       

      <atom:title>Categories</atom:title>

       

      </collection>

       

      <collection href="Suppliers">

       

       

      <atom:title>Suppliers</atom:title>

       

      </collection>

       

      <collection href="Persons">

       

       

      <atom:title>Persons</atom:title>

       

      </collection>

       

      And a couple of other tables.

       

      The Relationship between Products and Categories, for example is visible (with $metadata inquiry) like this

      <Association Name="Product_Categories_Category_Products">

       

      <End Type="ODataDemo.Category" Role="Category_Products" Multiplicity="*"/>

       

      <End Type="ODataDemo.Product" Role="Product_Categories" Multiplicity="*"/>

      </Association>

       

      To use these data effectively in Tableau, I need to be able to associate the Products with Categories. This joining operation requires another data source so that I can determine (e.g.) Products are in which Categories.

       

      How do I make that association available in Tableau Desktop?