Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Email Output/File Links

hoye
7 - Meteor

Hello All-

 

I have a workflow that uses about 4 inputs, 2 of the inputs, I would like to add a link to in my email output to those 2 input files, these files get updated and replaced multiple times a day. Is there a way to link the most recent files in the email, as well as displaying the DATE MODIFIED shown in the image below? I am guessing I will use a directory tool, in the email portion of my workflow, but I am not having any luck figuring it out.

 

email output.jpg

If you have any clarifying questions, let me know!

 

And thank you to whoever willing to help!

 

-e

1 REPLY 1
rzdodson
12 - Quasar

@hoye couple of things to unpack: building your output file path that you want referenced, and then displaying the modified date within that email.

First, I would build out the output path for where the file is being saved. Then, use a Block Until Done tool to output the data to that path (Output Anchor 1 from Block Until Done). Then, I would use that Output Path as a referenced field in a Text tool.

 

Second, I would get the list of files that are within that directory you are referencing. Get the LastWriteTime field from the Directory tool, and then append that field to the data set that feeds your Report Text/Email tool combo that you'll use to send the email out to your team.  Those new fields we built in the workflow will be available in the Report Text's "Available Fields" drop-down for you.

 

Solution.png

 

Report Text.png

Labels
Top Solution Authors