Transpose During Load Based on Field

Senor_Dai · ‎2023-07-10

HI.

I have a sample Dataset :

I need to show the flow that users's take through our site.

During the load I'd like to mark the start of the a user's session by the first occurrence of Event_Desc = "Home_Page' and then using the EVENT_DESC field create a table that creates a new column for each EVENT_DESC value in TimeStamp order eg :

A few things to note is that there isn't a limit as to the number of Pages a user can visit

If anyone can offer any advise on achieving this I'd be very grateful.

Thanks,

Senor Dai

Mark_Little · ‎2023-07-10

How i would approach this is by using the Peek or Previous function in Script to assign the Page no in a new field.

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/InterRe...

Then you could use a pivot table front end to show the report you have there.

Client Managed

Data Load Editor

General Question

Script