Hello,
i am trying to automate last three tabs by making Batch Marco but having trouble. can you help me how can i build these batch macro to automate last three tabs.
For the output, you can choose to output it normally or use a Formula tool + Text Input tool to set the path and specific sheet, then use the output tool to get said path for export (then drop the fields generating the output path and make sure to tick the output box for drop field (full path)). Make sure to use the control containers to get you A B C outputs per sheet accordingly.
@caltang
Wow this is tremendously helpful. actually i was trying to build macro with dynamic tool and getting some error message. but this is very much helpful. appreciate for your help.
@kauser You mean you want to automate the process of generating the last there tabs from rest of tabs?
Normally we will ask you to show what has you done so far.
you can try to explore these toolTransposeCrosstabDynamic Inputit a quite simple task after learning these 3 tools. hint:
@AncientPandaman Our flow is suprising similar, though yours looks simplier.
@Qiu it actually quite annoying to get the sheet name for further action. saw someone raise idea for to have an Option to output sheetname. just no enough ppl support the idea.
@AncientPandaman I am using the method in weekly challenge #499 with 2 Dynamic Input tools.https://community.alteryx.com/t5/Weekly-Challenges/Challenge-499-Where-is-Waldo/td-p/1427290
@kauser I would like to share mine also.
