Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Difference in hours between duplicates

Hi everyone 🙂   I am having a problem, hope you can help. I need to have the differente in hours between duplicates. Example:   Date Time                   SESSION_ID 24/01/2020 10:00       10...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

parry2k sorry for not being explicit.

If an id has 10 duplicates, I need to have the time difference in hours between consecutive id's. An example:

 

Session_ID   Date Time                    The column I need

111               10/04/2020 10:00            NaN

111               10/04/2020 11:00            1

111               10/04/2020 12:00            1

111               10/04/2020 15:00            3

111               11/04/2020 01:00            10

112               11/04/2020 10:00            NaN

111               11/04/2020 11:00            10

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak thank you so much for your solution. Looks like exacly what I need.

    For some reason, it is constantly giving me a memory error. Even with small amounts of data. 

     

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        amitchandak thank you very much for your help. 

        I think this wont work in Import Mode since it is always giving me the memory error.

         

        And it doesnt work in direct query, right?