Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need Guidance with Transpose and Export to Multiple Files

thd-data-analyst
7 - Meteor

Hello Kind Folks,

 

I have a question that is troubling me.

 

I have data that goes like this:

 

CategoryAttributeValues
Cat1Attrib1Ball, Bat, Mat
Cat1Attrib2Man, Women, Boy, Girl
Cat1Attrib3Car, Bike, Bus
Cat2Attrib4Red, Blue, Green
Cat2Attrib5Sofa, Table, Chair, Cabinet

 

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

 

Attrib1Attrib2Attrib3
BallManCar
BatWomenBike
MatBoyBus
 Girl 

 

Cat2 file must be like this

 

Attrib4Attrib5
RedSofa
BlueTable
GreenChair
 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?

11 REPLIES 11
BrandonB
Alteryx
Alteryx

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

 

batch macro.png

thd-data-analyst
7 - Meteor

Thank you so much for all the help @BrandonB .

Labels