Need Guidance with Transpose and Export to Multiple Files

[thd-data-analyst]

Hello Kind Folks,

I have a question that is troubling me.

I have data that goes like this:

Category	Attribute	Values
Cat1	Attrib1	Ball, Bat, Mat
Cat1	Attrib2	Man, Women, Boy, Girl
Cat1	Attrib3	Car, Bike, Bus
Cat2	Attrib4	Red, Blue, Green
Cat2	Attrib5	Sofa, Table, Chair, Cabinet

I want to export one file for each Category. So the Cat1 file must be in this format:

Attrib1	Attrib2	Attrib3
Ball	Man	Car
Bat	Women	Bike
Mat	Boy	Bus
	Girl

Cat2 file must be like this

Attrib4	Attrib5
Red	Sofa
Blue	Table
Green	Chair
	Cabinet

I know I need to transpose the data and export into multiple files. Ideally I should be doing the transpose for each category and then export and go to the next category and so on. Can anyone suggest me how I can do this?

[BrandonB · Accepted solution]

You are really close! You just need to make sure that the batch macro is set to "Group by" the Category field as shown in this link: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/t...

If you download my example above you can see where I have done this

[thd-data-analyst]

Thank you so much for all the help @BrandonB .