1 Reply Latest reply on Nov 13, 2013 12:49 PM by Matt Lutton

    Combining data sets - different dates

    pete.weir

      I have two data sets with separate measures that I want to perform analysis on simultaneously.  I have a key that has a customer number associated with it that I plan to join on.

       

      The two .csv files both have dates and I have changed so that they are both in MM/DD/YYYY format. I'm only going to analyze this data on a monthly basis.  Do I need to join the date fields as well (even though the days are different) to be able to analyze the two data sets?

       

      I have the analysis completed in separate worksheets, when i try to establish an extract to combine them, I get far more rows than i should and the numbers don't tie.

       

      What am I missing?