topic Re: Splitting output to mutiple excel workbook in Alteryx Designer Desktop Discussions

Splitting output to mutiple excel workbook

Laksh345 — Thu, 09 May 2024 11:19:26 GMT

I have below data where the output should be saved in a separate workbook in the same path based on the AP processor field. Data of Kishore should be saved as a separate excel file and same for others

Re: Splitting output to mutiple excel workbook

DataNath — Thu, 09 May 2024 12:24:39 GMT

Hi @Laksh345, the method for splitting to multiple files involves creating a dynamic filepath and replacing this in the Output Data tool. I made a macro that handles this under the hood for you - you just need to select the Multiple Files option and configure the rest as necessary: https://community.alteryx.com/t5/Community-Gallery/Output-to-multiple-Excel-files-or-sheets/ta-p/951995

Re: Splitting output to mutiple excel workbook

Blockprogramming — Tue, 14 May 2024 14:33:54 GMT

If the number of "AP Processors" are a fixed and relatively small group, then just set a number of parallel filters that filter by the "AP Processor" and save to a dedicated file for that "AP Processor".

Otherwise a macro is going to be your best bet. Looking at your scenario, a batch macro seems most appropriate to me.