Hi there, I currently have a table that looks like this:
| DA_DateTime | DA_Payload | DA_Field Numbers |
| 19/06/2020 15:29 | Process starting for ticket: ACM-155 | 1 |
| 19/06/2020 15:29 | User: 'afurnish', Group: '(DB) Prod-10-snapshot-DBS.Elevation - ReadOnly', Approver: 'afurnish' | 2 |
| 19/06/2020 15:29 | Andy Furnish has been added to group (DB) Prod-10-snapshot-DBS.Elevation - ReadOnly | 3 |
| 19/06/2020 15:29 | Ticket ACM-155 has been resolved with the comment 'Access Granted' | 4 |
| 22/06/2020 09:02 | Process starting for ticket: ACM-163 | 1 |
| 22/06/2020 09:02 | User: 'vbernik', Group: '(DB) Prod-10-snapshot-DBS.Elevation - ReadOnly', Approver: 'ohalberthal' | 2 |
| 22/06/2020 09:03 | Volha Bernik has been added to group (DB) Prod-10-snapshot-DBS.Elevation - ReadOnly | 3 |
| 22/06/2020 09:03 | Ticket ACM-163 has been resolved with the comment 'Access Granted' | 4 |
And I would like to crosstab it into something that looks like this:
| 1 | 1_DateTime | 2 | 2_DateTime | 3 | 3_DateTime | 4 | 4_DateTime |
| Process starting for ticket: ACM-155 | 19/06/2020 15:29 | User: 'afurnish', Group: '(DB) Prod-10-snapshot-DBS.Elevation - ReadOnly', Approver: 'afurnish' | 19/06/2020 15:29 | Andy Furnish has been added to group (DB) Prod-10-snapshot-DBS.Elevation - ReadOnly | 19/06/2020 15:29 | Ticket ACM-155 has been resolved with the comment 'Access Granted' | 19/06/2020 15:29 |
| Process starting for ticket: ACM-163 | 22/06/2020 09:02 | User: 'vbernik', Group: '(DB) Prod-10-snapshot-DBS.Elevation - ReadOnly', Approver: 'ohalberthal' | 22/06/2020 09:02 | Volha Bernik has been added to group (DB) Prod-10-snapshot-DBS.Elevation - ReadOnly | 22/06/2020 09:03 | Ticket ACM-163 has been resolved with the comment 'Access Granted' | 22/06/2020 09:03 |
How would I use the crosstab tool to do this please? Thanks in advance! 🙂
