I have a two-step process. One application and one workflow. On the application it asks the end user to upload three excel files and then run the application. Within the application I am using multiple joins, data cleansing, filters, selects, etc. Then after I have the data formatted in a certain way I am using the formula tool to create a excel file using the name of a column of data. Example I have 20 different values from the name column. I am using the output data tool to take the file/table name from the field and change the entire file path to create a new excel file. Now I have 20 different excel files with their unique names located in a folder on my network.
The workflow is super basic. It takes the output excel file -> summarize tool -> report text tool (to display the last date this application has running) -> and then finally the email tool.
My issue is that I currently have 40 of these connects above. 20 unique name files with special data and 20 unique excel files without special data. Having multiple (2000+) emails address is my main issue. Is there a way to make sending out emails to end users easier? I was thinking maybe creating a excel file “email mailing list” with column A be the end user email address and then column B would location the unique excel file. The reason behind doing this is if I ever needed to add someone I could simply open the “Email mailing list” and add the end user instead of looking around my workflow to find the unique connection and then manually adding them. Any thoughts or suggestions into how to make this workflow process operate smoothly? Maybe a special type of macro. I have only been working with Alteryx for about a month now.
Thank you,
