Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
timpoismans
Specialist
Specialist

Transforming log file to user journey

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:

userIDLocationTimestamp

 

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:

userIDLocation1Location2Location3LocationX
1TimestampTimestampTimestampTimestampTimestamp
2TimestampTimestampTimestampTimestampTimestamp
TimestampTimestampTimestampTimestampTimestamp

Any help is appreciated.

 

Regards,

Tim P.
P.S.: I've included a (very) small file with dummy data.

3 Replies
timpoismans
Specialist
Specialist
Author

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:

userIDLoginHomeSettingsHomeMapSettingsLogout
128/01/2019 15:56:4028/01/2019 15:56:4328/01/2019 15:56:4828/01/2019 16:01:4828/01/2019 16:05:4828/01/2019 18:05:4828/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