2 Replies Latest reply on Aug 19, 2016 7:37 AM by Daena Day

    Trouble connecting three years of data

    Daena Day

      Hi!  First time user.  I am using an Excel file as the data source.  The Excel file has numerous tabs of the same tables from the same database over 3 years.  I wanted to show how things have changed over three years.  I started with one of the tabs and brought in the same tabs from the other two years.  The first year was 2015, an inner join was created to the 2014 version and then when I added the 2013 version, it looks like it did an inner join from the 2015 to the 2013 versions.

       

      Each of those three tables normally has about 380 lines.  When I look at the resulting table in the Data Source tab, it only has 151 rows.  Is there a limit on the number of rows?

       

      Thanks!