Several Output Excel files keeping the same single template

Guilherme91

Hi all,

Can someone help me creating several countries excel files from 1 template?

I have 2 inputs in Alteryx.

• “Economic” – Economic data for several countries
• “Sales” – Sales data for several cities in the same countries

Those countries are divided in aggregations, such as “Benelux”, “Nordics”, etc..

I have a template with two charts and tables that are populated by the additional two tabs in the template file. My goal is that Alteryx outputs populates “Economic Data” and “Sales” tabs with the data for each country which would automatically populate the charts and tables.

In addition I need it to save the file as “Analysis_country xxxx” in the aggregation folder. The folder structure is as the example below:

So, from the template file I need to create as many files as countries in the input files (Economic and sales) and save them in the correct aggregation.

Is this possible?

Thank you very much,

Guilherme Neves

Template.xlsx

Economic.xlsx

Sales.xlsx

DavidP

My reply post keeps getting rejected, hopefully they don't all come through at once.

So the error you're seeing is when the Run Command tool is trying to execute the DOS commands and they fail. Here's what it's trying to do:

1. Delete all existing files in the Aggregation folders.

2. Copy clean copies of the Template file to relevant folders with correct name

This assumes that the Aggregation folders already exist inside the Sheets folder, like this. Economic, Sales and Template should also be in the same folder as the Sheets folder.

                                           Sheets Folder

I'm guessing that the Aggregation folders don't exist in the Sheets folder, or some files are not in the right place, which is making it fail in your case.

The workflow is designed to pick up the folder path from where the Sales and Economic files are stored. If you create the Aggregation folders and make sure your files are in the right place as shown above, the attached should correctly create copies of the files in the right folders and write the data to the Sales and Economic Data sheets in the relevant files. 

Please use the new version attached to this post.

There is currently an additional problem in that it seems to mess up the rest of the Excel file a little, but I'm still looking at that.

copy template file to multiple folders.yxmd