4 Replies Latest reply on Nov 12, 2013 12:53 PM by Lu Cheng

    link two data sources together

    Lu Cheng

      I have one data file for campaign history, and another for tickets sold.

       

      I am trying to build a dashboard that illustrates campaign's impact on ticket sales so I linked these two files on date. Somehow, what then happened is, only the dates that are available in both data sources are kept. In another word, it performed like an "inner join".

       

      I would like to ask if there is anyway I can have an "outer join", or I will have to do it in the database first?

       

      thanks.