This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
add the full file path as a field with a Formula tool. enter it as literal text, concatenating whatever dynamic values you need along the way (i.e. the corresponding timestamp or whatever). you can't just put "datetimenow()" in the formula tool - the timestamps will certainly be different than the timestamp used to create your zip file. so you just need to be careful about syncing the timestamp, or whatever other values, between the name of the .zip you're creating, and the string of the full file path you're creating in the formula tool.
then in your email tool, set the attachment to reference that field with the full file path ("File Name From Field Value"). and use block until done along the way so your email tool doesn't try to attach something still being written
Thanks for your response @mst3k . I knew it would be the way, but as I said, it is not possible, or at least I don't know how to do it in Alteryx. This is because the batch file creates the zip file name, and I couldn't find a way to get the files' name (I explained why it's not possible in the original question).
There is no way to estimate or sync the time stamp on the zip file name and the workflow timestamp creation.
Would you please clarify more or tell me which part I am missing from your response?
is it possible to mock up a quick and dirty workflow that removes any sensitive info you can share and shows what you're doing now? I didn't realize .zip can't be output directly - you have to use a CMD command to do it? Is that right? you should still be able to feed your filename/path dynamically into a CMD command using the alteryx tool. so you determine the filename (including user id, timestamp, etc) and feed that value into the .bat command that creates the .zip, and also feed it to the email tool as the filepath? i might be completely misunderstanding the obstacle though