6 Replies Latest reply: Feb 28, 2018 11:21 AM by celine xu RSS

    join two file with datetime but datetime have different format and content

    celine xu

      Hi , I have 2 file from 2 system so have the datetime with different format

      as follow

      Screen Shot 2018-02-28 at 10.02.51.png

       

      is that the case I need to change the righthand side datetime format?

      I also have date, time, and the_hour_of_a_day exist in the file.

      if datetime not working, could I use 'Date' and 'time' join at the same time to represent the datetime?

       

      if I can, how?

       

      and if I have the right format

       

      could i use both datetime and also the other floor to join the data together? (inner join will be nice)

       

      here is the app with the data for your info

       

      Thank you!