I want to write to multiple Excels at the same time and send an email.

[SaoriYamguchi]

I would like to create a workflow.

In addition to the URL "How to output to the Excel template file below", I want to realize the following

・ I want to write in a remote place

・ I want to write to multiple files at the same time

https://community.alteryx.com/t5/%E3%83%8A%E3%83%AC%E3%83%83%E3%82%B8%E3%83%99%E3%82%B9-%E6%97%A5%E6...

I can actually use the tabular data reporting tool to capture multiple data (from companies), create multiple reports, and send them to different email addresses.

However, I consulted because I would like to use the Excel template currently used by the company.

Thank you very much.

[mceleavey]

Hi @SaoriYamguchi ,

You can do this in a number of ways:

1. Create a filename in a formula tool, containing the unique identifier that will differentiate the output sheet. For example "<folder path>\filename"+[Department Code]+".xlsx|||Sheet1".

You then use this field in the output tool:

2. You can use the render tool to output to individual files based on a grouping field.

I hope this helps,

M.

[SaoriYamguchi]

Thank you！

・ I want to write in a remote place
・ I want to write to multiple files at the same time (please see the picture)
and
・Preferably,I don't use the render Tool.

[Qiu]

@SaoriYamguchi 
So correct me if I understand wrongly.

1. Save the output files in a remote location: This should not be an issue as long as the path is acessible.

2. Write to multiple Excels with the same template?

[mceleavey]

Hi @SaoriYamguchi ,

I don't really understand. My previous post shows you how to write to multiple files simultaneously (see option 1).

The image you provided does not show it writing to multiple files, but to a single file with multiple rows.

M.

[SaoriYamguchi]

Thank you very much.

Actually, I 'd like to make multiple inputs, one workflow, multiple outputs at the same time.

Normally, it is better to make a document using the Reder tool, but I would like to export multiple locations and multiple files to the original template in Excel, if possible, at the same time.

(Since the reference community was not found, I will attach my own workflow.)

1. Save the output files in a remote location: This should not be an issue as long as the path is acessible.

→　thank you.

2. Write to multiple Excels with the same template?

→　yes.

[SaoriYamguchi]

Thank you very much.
Yes, It's very complicated.
I would like to create multiple inputs, one workflow, and multiple outputs at the same time.

[Qiu]

@SaoriYamguchi 
Let me share one workflow I made before to reuse one template for multiple outputs.
This is actually note easy, and it is a macro in macro flow.
I have tried to submit as an idea of weekly challenge and get declined for Run Command Tool is not secure. 😂
Try to explore it and see if it will work for you.