I have an workflow which is wring to an excel template by selecting records and then using control container to output to specific or defined ranges in that excel template. I want to do this process by building a batch macro. For example, my data has records from 1-50. I am using select records tool to select records 1-5 and then outputting to the excel template from A1-E5, then again select records from 6-10 and then outputting to the excel template from A10-E14 and so on. Is it possible to do this process by a batch macro? Need help to build the macro as I have never built a macro in Alteryx though I have gone thru the batch macro video. below is the screenshot of my workflow.
