Loop through Records and Replicate the Template using Iterative Macro or Reporting Tools

Question

Hi Team, I have the data (Required Input file) which needs to be replicated into multiple sheets based on the Record Numbers, and in each sheet, we should be having that specific Record Data and the sheet name be dynamic based on the dates as per the records. I'm trying to use Reporting tools, however, I was not able to achieve and when I tried iterative macros, somewhere it is missing and totally I got confused. Please help me get this done.

Attached is the Output required (Sample with explanation) image for your reference. Also attached is the required Input File for easy access. Thank you & Appreciate your help in advance.

Output Sample with Explanation.jpg

Required Input.xlsx

Required Output.xlsx

Felipe_Ribeir0 · Answer

Hi @Rahulkanth

Unfortunately, this is not a very simple task, but i will try to do it before of the end of the day.

If you want to give a try to it before, i see a way of doing it following this sequence:

1-Have an excel template ready

2-Use python to create a new excel file/tabs with this template structure ready to be populated

3-Populate the excel file/tabs

Those 3 steps were done in this other topic, it is just a matter of adapting to to your use case i believe.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Batch-macro-to-filter-countries-and-output-to-excel/m-p/1057369#M261554

Rahulkanth · Answer

Hi @Felipe_Ribeir0 , can you please help me with this issue?