2 Replies Latest reply on Aug 1, 2013 12:43 PM by Rodrigo Guerrero

    How to append dates for 2 different data sources

    Ayush Baheti

      I have 2 data sources - both excel, having the exact same headers. They are about patient medical records.

       

      Sheet 1

       

      ID     Location     Date     Temperature     Anything unusual

      1          A            11-3          99.1                    0

      1          A            11-4          99.5                    1

      1          A            11-5          99.3                    0

      2          B            11-3          99.2                    0

      2          B            11-4          98.7                    0

       

      Sheet 2

       

      ID     Location     Date     Temperature     Anything unusual

      1          A            11-7          99.1                    0

      1          A            11-8          99.5                    1

      1          A            11-9          99.3                    0

      2          B            11-7          99.2                    0

      2          B            11-8          98.7                    0

       

      We get new data every week. One of the options I have is just to copy all excel data in a new file and append it to the original one. Is there any other way so that my new date field will give me all the values from 11-3 to 11-8? (There is no date overlap in the data). There are more dimensional fields with only 0 and 1 as values.