Transforming log file to user journey

[timpoismans]

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.

[OmarBenSalem]

Please, refer to this:

https://community.qlik.com/t5/QlikView-App-Development/crosstable-reversed/td-p/446395

[OmarBenSalem]

Or else:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470

[timpoismans]

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