Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Working on a side project of mine, I was wondering if we could transform a log file to a user journey.
The log file would contain the following info:
userID | Location | Timestamp |
There would be multiple rows per userID, each session starting with a login and ending with a logout. Ideally, I'd like to have the data transformed to the following format:
userID | Location1 | Location2 | Location3 | … | LocationX |
1 | Timestamp | Timestamp | Timestamp | Timestamp | Timestamp |
2 | Timestamp | Timestamp | Timestamp | Timestamp | Timestamp |
… | Timestamp | Timestamp | Timestamp | Timestamp | Timestamp |
Any help is appreciated.
Regards,
Tim P.
P.S.: I've included a (very) small file with dummy data.
Please, refer to this:
https://community.qlik.com/t5/QlikView-App-Development/crosstable-reversed/td-p/446395
Thanks. I knew of the Generic Load, but I can't achieve my desired result with it.
The key part is that a session starts with a LOGIN and ends with LOGOUT. Everything else in between should be labeled out as locations. But the following scenario could very well be real:
userID | Login | Home | Settings | Home | Map | Settings | Logout |
1 | 28/01/2019 15:56:40 | 28/01/2019 15:56:43 | 28/01/2019 15:56:48 | 28/01/2019 16:01:48 | 28/01/2019 16:05:48 | 28/01/2019 18:05:48 | 28/01/2019 18:10:48 |
So basically, userID 1 visits some pages multiple times. Using the Generic Load, it would end up as multiple rows for userID. While the only time a userID could have more than 1 row, is when it has more than one session.
Regards,
Tim