3 Replies Latest reply on Oct 6, 2016 7:45 AM by David Li

    Date from multiple datasources

    Dyna Lee

      Hi everybody

       

      I have 2 data sources

       

      1. Access: contains all data (article, stock, date, value) from the very beginning of time until/with LAST MONTH.

      2. Oracle: contains all data (article, stock, date, value, article description, warehouse, article Group, etc.) of the current month

       

      I would like to have a list with all the stock from the very beginning of time until the current month but somehow I can't tell Tableau use date2 (current month) when date1 is empty. (Tableau Needs always a Aggregation: see calculated field date_over_all).

       

      Is there anyway to merge the data of the 2 sources? Concretely I want to have a UNION from the 2 datasources.

       

      Thanks a lot and best regards

       

      dyna