Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

How to crosstab multiple fields?

arthurmauk
6 - Meteoroid

Hi there, I currently have a table that looks like this:

 

DA_DateTimeDA_PayloadDA_Field Numbers
19/06/2020 15:29Process starting for ticket: ACM-1551
19/06/2020 15:29User: 'afurnish', Group: '(DB) Prod-10-snapshot-DBS.Elevation - ReadOnly', Approver: 'afurnish'2
19/06/2020 15:29Andy Furnish has been added to group (DB) Prod-10-snapshot-DBS.Elevation - ReadOnly3
19/06/2020 15:29Ticket ACM-155 has been resolved with the comment 'Access Granted'4
22/06/2020 09:02Process starting for ticket: ACM-1631
22/06/2020 09:02User: 'vbernik', Group: '(DB) Prod-10-snapshot-DBS.Elevation - ReadOnly', Approver: 'ohalberthal'2
22/06/2020 09:03Volha Bernik has been added to group (DB) Prod-10-snapshot-DBS.Elevation - ReadOnly3
22/06/2020 09:03Ticket ACM-163 has been resolved with the comment 'Access Granted'4

 

And I would like to crosstab it into something that looks like this:

 

11_DateTime22_DateTime33_DateTime44_DateTime
Process starting for ticket: ACM-15519/06/2020 15:29User: 'afurnish', Group: '(DB) Prod-10-snapshot-DBS.Elevation - ReadOnly', Approver: 'afurnish'19/06/2020 15:29Andy Furnish has been added to group (DB) Prod-10-snapshot-DBS.Elevation - ReadOnly19/06/2020 15:29Ticket ACM-155 has been resolved with the comment 'Access Granted'19/06/2020 15:29
Process starting for ticket: ACM-16322/06/2020 09:02User: 'vbernik', Group: '(DB) Prod-10-snapshot-DBS.Elevation - ReadOnly', Approver: 'ohalberthal'22/06/2020 09:02Volha Bernik has been added to group (DB) Prod-10-snapshot-DBS.Elevation - ReadOnly22/06/2020 09:03Ticket 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! 🙂 

1 REPLY 1
atcodedog05
21 - Polaris

Hi @arthurmauk 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1634208368154.png

 

Hope this helps : )

Labels