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.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
Hello, I have a folder that constantly gets updated every Monday with csv files that I would like to send out to people. Each of the files are unique to certain teams in our company and for that reason I'd like to create a way using the email tool to only send each respective file to the team it goes to. *Also not all the time does every team receive an email, it's only when they have stored data in that folder for that particular monday*
I believe this would mean that I'd have to utilize the field columns in attachments and the to section, but how would I do that to get what I need done? There are over 20 teams that I'd need to email constantly with the files updated in the folder so creating a bunch of different filters won't work for me. There has to be a way to get it all to work with some type of Macro.
Hard for me to visualize without actual data/process, but can you get your workflow, pre-Email tool, to a point where you basically have it down to, on a per-record basis, who the email is going to and what the attachment(s) are?
With the Email tool, it will send one email per record. So if you have, say, 100 records with the same exact "to" and "attachment" values, then 100 emails will be sent to that same "to" list with that same "attachment". Add a Summarize tool and group by those two fields so you get unique "to" - "attachment" groupings.