Grouping Columns under New Columns from Fields

[jenjeong]

Hello,

I'm wondering if the transformation from the original data to the desired state is possible in Alteryx using one workflow.

The workflow I had before had too many manual reordering and renaming of columns, which I want to avoid since the data is dynamic and some groups may not have values for one group but may have values for another.

Any suggestions would be greatly appreciated, or even just a quick insight into if this can be achieved.

Current Workflow

Input to Desired State

[Yoshiro_Fujimori]

Hi @jenjeong ,

I tried to follow your format except for Subtotal Group A/B and multiple header rows.

I hope this might be of some help.

(I would use BI tool (such as Tableau) to do this kind of data visualization.)

Workflow

Output image

Gr2	A_X	A_Y	A_Z	B_X	B_Y	B_Z	Total
Carrot		18	14		12	2	46
Banana	4		6		13	7	30
Apple	10	10		11	13		44
Total	14	28	20	11	38	9	120