Batch macro to filter countries and output to excel

@Felipe_Ribeir0 it worked fine on the server. So all good. Many thanks Felipe

@DanielCarro i am glad it worked.

Please accept my answer as a solution so the topic can be considered closed and someone with the same problem can find this answer too.

Thanks!

All comments

@DanielCarro the attached workflow demonstrates how this can be accomplished with the Output Data tool. By replacing the output path with data from the workflow, you are able to write data dynamically to different sheets, or files.

dynamic_output.yxmd

KAkuffo

HI @DanielCarro

The attached screenshot shows the configuration required for the output data tool to output to seperate sheets (Change file table name with take file/table name from field) in excel or files in other format types.

Hi MatthewO,

Nearly, your output creates tabs alongside. But what I needed is the country to go to the template and to sheet1 and paste the data in the range. So one country per excel file.

Kind Regards,

Dan

@DanielCarro this can be accomplished with a small change to the file path created in the Formula tool. The attached version writes to different files.

dynamic_output_v2.yxmd

@MatthewO it still creating tabs for the countries

@DanielCarro just confirming that you ran the workflow with the _v2 suffix. It generates 2 separate files when run on my end. The only change is that the value of the Output field is updated in the Formula. For use in your workflow, you will likely want to update "%temp%" with the appropriate directory.

@MatthewO following your guidance

in the second pic I get a C inside a bracket

the last pic is the extension of pic 2, wasn't able to capture all in one shot

Not sure where I might gone wrong

@DanielCarro I think the issue is the configuration shown below. I would update this to "Change Entire File Path".

Hi @DanielCarro

Please try this workflow. I shared this case in the gallery too, it is very useful i think: https://community.alteryx.com/t5/Community-Gallery/Copy-files-between-folders/ta-p/1056621

Just adapt it to your use case (the datasets/paths/range)

1-I have a default template

2-I am using a macro to copy this template for each country of my dataset

3-I am writting the data inside of each country/template

Example_Template.yxzp

@MatthewO now it creates the file but doesn't keep the initial format of the template. Maybe instead of overwrite, I need to select something else

@Felipe_Ribeir0 it works fantastic. The only issue is that does work ok on the gallery side (server)

@DanielCarro what error are you getting? It should work on server.

@Felipe_Ribeir0 I haven't checked the gallery yet but will check it tomorrow, and revert back

@DanielCarro just be sure that the server machine has access to the network folders that this workflow will use and that you pass the filepaths as UNC and it should work without problems.

Hi @DanielCarro

It worked?

@Felipe_Ribeir0 it worked fine on the server. So all good. Many thanks Felipe

@DanielCarro i am glad it worked.

Please accept my answer as a solution so the topic can be considered closed and someone with the same problem can find this answer too.

Thanks!

aba

Hi @Felipe_Ribeir0 ,

I have a similar issue and I think the macro MC_COPYFILES would be the solution but can't seem to get the macro working. Basically, I'm trying to output to a .xlsm file but I keep getting an error on the macro (Tool #10 specifically).

What configuration is required to update and use the macro?

Thanks,

Aba