Batch Macro seems to be stuck at the first row

Question

Hello,

I tried to follow a tutorial to design a batch macro that copies a Excel template to several Excel files based on the name of the employee. Then we feed the sheet "Data" in each file so the file updates itself with the formatting of the template. However when i run the macros, the first one (which copies de template and is supposed to create 2 files for Jane and John) seems to run only on the first row.

Can you help me please !!!

Thank you very much

Copy_Excel_File.yxmc

Export_to_Excel_2.yxmc

Export_to_Excel_Part 02.yxmd

Sales_Jane.xlsx

Sales_John.xlsx

Qiu · Answer

@Phimpha 
Maybe it is because you are using the path in OneDrive?
I simply modified the path to my local drive and it is working.

Export_to_Excel_Part 02.yxzp

lynnesonney · Answer

Hi @Phimpha  This may be a bit more complex than needed. Have you tried using the 'Output data - 'Take File/Table Name From Field'' Functionality?

it's actually the next video from the same individual on youtube. This can be used to generate separate files, as shown in the video, or separate tabs in the same excel based on a specific field in the data.

https://www.youtube.com/watch?v=7uXMwORCPZg

happy to post a separate example if you think that would help!

Phimpha · Answer

The tutorial I followed : Export to Excel with Alteryx - #02 Using Excel Templates - YouTube