How to Transform Cross-Tab Data to List Format in Alteryx

Could someone guide me on the best approach to achieve this transformation in Alteryx? Any tips on using specific tools or configurations would be greatly appreciated. Note also that there are a lot more reject reasons that will be added and hoping that the total will also adjust.

I have attached the input file for your reference. Below is also the screenshot.

Input reject.PNG

This is the output I would like to generate.

reject analysis output.PNG

Please help.

Thanks,

Kamen

Sample Input File.xlsx

Workflow

Output

Common Use Cases

Accepted answers

binu_acs

@KamenRiderIf it still isn't working, please provide some sample data that is similar to the actual records you are facing the issue with. Also is the provided workflow working for you before connecting your actual data?

binu_acs

@KamenRider updated the workflow

Reject Account Analysis.yxzp

All comments

VarunShashidhar

Hi Kamen,

you need to use the crosstab function to get the desired output. i have attached the workflow.

Regards,

Varun

New Workflow.yxmd

VarunShashidhar

the expected result will match with this workflow if you do not consider the date column

New Workflow.yxmd

KamenRider

Hi @VarunShashidhar

Thanks for the response however, I need the output to look like this as shown below. I hope you can help me on this.

reject analysis output.PNG

Thanks,

Kamen

binu_acs

@KamenRider

Table_Format_23052025.yxmd

KamenRider

Hi @binu_acs,

Thanks for the response. The workflow is good however is there a way we can make the ID dynamic? I encountered an error when a new ID comes in. And I do hope same also with the date since this is being reported every week with different data. See below screenshot.