Which is a log of users performing different categories of activites. Due to the nature of the system that produces this log, I do not have an end timestamp for these activities, it only records when an activity is started. Does anyone have any ideas how I can break out the starting timestamp of the next activity to another column, so that the table looks something like this:
The data is from an SQL database that I load into Qlik by query, so if there are any SQL wizards here with a neat trick to get this done right at the source, I'm all ears. Or if there's some Qlik trick that can append such a column to the table afterwards, that's just as fine by me. I really have no clue where to even start with this.