Webi help (List to columns)

[system]

Hi all,

I am trying to create a data table but the way in which the data is brought back is proving difficult for me.

I have an object named [Event] within this sits different types of events that occur. eg Running, Sprinting, Jogging, Jumping

Associated with this object is [Event_Result] which essentially just gives a measurement against each [Event].

My data is returned as a list; example below

[Date]…[Session_ID]…[Person_ID]…[Event]…[Event_Result]
01/07/2020…001…PID001…Running…20
01/07/2020…001…PID001…Sprinting… 15
01/07/2020…001…PID001…Jogging… 60

01/07/2020…002…PID001…Running… 10
01/07/2020…002…PID001…Jumping… 100
01/07/2020…002…PID001…Jogging… 15

02/07/2020…003…PID001…Running… 25
02/07/2020…003…PID001…Sprinting… 20
02/07/2020…003…PID001…Jogging… 70
02/07/2020…003…PID001…Jumping… 110

what I am after is below: but not sure how

[Date]…[Session_ID]…[Person_ID]…Running…Sprinting…Jogging…Jumping
01/07/2020…001…PID001…20…15…60
01/07/2020…002…PID001…10…15…100
02/07/2020…003…PID001…25…20…70…110

im not sure how to do it

any help is appreciated[/b]

---

mo_moosa (BOB member since 2020-07-01)

[system]

convert it into a crosstable with
[Date], [Session_ID] and [Person_ID] in rows
and [Event] in columns
and [Event_Result] as measure

---

n8aktiv (BOB member since 2018-12-29)