Hi everyone,
I am new to Alteryx and currently working on a project with two input datasets. My requirement is to generate separate Excel output files for each unique State, where each Excel file contains 5 worksheets (tabs).
I have used Blob tools with an Excel template (for better formatting) and was able to generate the outputs. For example, when I have two States, I correctly get two Excel files, each containing 5 worksheets. However, the issue is that both Excel files contain data for all States, instead of each file containing data for only its respective State.
Additionally, my original Excel template is getting updated, whereas I would like the template to remain unchanged and only create separate output files.
I also tried using a Batch Macro to control the State, but I am still seeing the same issue where all State data appears in each output file. At this point, I am unsure how to correctly control or filter the data by State so that each Excel output contains data for only one State.
I have attached a screenshot of my workflow for reference. Any insights or suggestions on how to approach this would be greatly appreciated.
Thank you!
