piovt table

[shayde]

HELLO,

I WANT TO CREATE A PIVOT WITH TWO FIELDS IN THE COLUMNS.

ATTACHED IS AN EXAMPLE OF THE PIVOT I WANT TO CREATE.

THANK YOU FOR YOUR HELP

[mutama]

Hi @shayde , this tutorial guide on creating pivot table in Alteryx may be useful for your case: https://www.theinformationlab.ie/blog/how-to-pivot-data-using-alteryx/ 

It leverages the Cross-Tab tool under the "Transform" category. Here's an accompanying video guide as well: https://www.youtube.com/watch?v=pdf11ZWNysc 

[ponraj]

We can achieve this by concatenating column fields. Attaching a sample workflow with your sample data. Hope this is helpful.