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

[KamenRider]

Hi

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.

 

This is the output I would like to generate. 

Please help.

Thanks,

Kamen

 

[VarunShashidhar]

Hi Kamen, 

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

Regards,

Varun 

[VarunShashidhar]

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

[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.

 

Thanks,

Kamen

[binuacs]

@KamenRider 

[KamenRider]

Hi @binuacs,

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.

 

Looking forward for your continued assistance.

Thanks,

Kamen

[binuacs]

@KamenRider I changed the summarize tool with with a dynamic summarise macro, it should work for any dynamic id values

[KamenRider]

Hi @binuacs 

What does this error means and how do i fix it.

Thanks,

Kamen

 

[binuacs]

@KamenRider connect the output from the summarise tool

[KamenRider]

Hi @binuacs 

I have apply the "con_cat expression" as advised however I have new error. Please below:

 

Please advise:

Kamen