1 Reply Latest reply on Aug 1, 2018 12:54 PM by Deepak Rai

    Combine Dimensions

    Taylor Lile

      Hello,

       

      I have two separate data sources where both have incomplete sets of data. I would like to somehow join them in Tableau which gives me a combined list of all Lead Sources. When I join them in normally, I get two separate dimensions when I would like one dimension that has them all combined. For example:

       

         1st data source

      Lead SourceSales
      Office500
      Tradeshow200
      Parking Lot560

       

           2nd Data source

        

      Lead SourceExpenses
      Office5600
      Tradeshow255
      Soccer Field115

       

      I want the results to be:

         

      Lead SourceSalesExpenses
      Office5005600
      Tradeshow200255
      Parking Lot560NULL
      Soccer FieldNULL115

       

      Like I said, I thought a full join would do the trick, but when i get into tableau after I join the two data sources, I have two separate dimensions when I only want to call on one.

       

      Any help would be greatly appreciated.

       

      Thank you!