Batch Macro output for excel returning one tab as opposed to 5

[LesediNakin]

Hi 

I am Lesedi still a beginner with Alteryx I need some assistance.

I am trying I have built a macro but when I run it on a workflow to get an output i only get one Tab as opposed to 5 

Kind Regards,

[FrederikE]

Hey @LesediNakin,

You did not share the macro, only your main-workflow. 

Looking like this for us: 

To package workflow and macro together, please export the workflow (see pic.)

This will create a shareable .yxzp-file which we can open. 

[FrederikE]

Also, it doesn't look like the macro even matters for your problem.

To create multiple sheets with the render tool check this blog post: https://community.alteryx.com/t5/Engine-Works/How-to-Render-to-Multiple-Named-Excel-Sheets/ba-p/1015...

[LesediNakin]

@frederikeE
Thanks for the reply