7 Replies Latest reply on Nov 16, 2018 5:14 AM by Michael Gillespie

    Data Blending - Cube and Excel - Missing Data

    Paul Weber

      Hello.

       

      I've created an actuals to budget table in tableau.  My primary data source (with actuals) is a server data cube.  My secondary data source (with budget) is an Excel file.

       

      I've matched the two files on "Product" and everything pulls in fine from Excel except for one product.  The issue is it is a low volume product that we haven't yet sold this year, so there are no actuals for it, and that product row doesn't appear in the table.  Because there are no actuals, it doesn't pull that product budget data into the tableau table from Excel.

       

      Is there a way to get that product from Excel to appear if we don't have actual sales for it in the data cube?

       

      Thanks.

       

      Paul