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%9C%AC%E8%AA%9E/%E3%82%A8%E3%82%AF%E3%82%BB%E3%83%AB-%E3%83%86%E3%83%B3%E3%83%97%E3%83%AC%E3%83%88%E3%83%95%E3%82%A1%E3%82%A4%E3%83%AB%E3%81%B8%E3%81%AE%E5%87%BA%E5%8A%9B%E6%96%B9%E6%B3%95/ta-p/371943

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.