Good morning,
I am currently working on an automated report as a csv file. However, I need it split into two tabs in one report. Is that possible and if so whats the best way to make it happen?
Thanks for that clarification. Here's how I would go about this:
- Create the tables and assign a sheet name to each. Layout these so the sheet name field will be used later.
- Append a file name to these layouts.(using "%temp%" is handy here)
- Block Until Done
- First out of the BUD: use a Render tool to generate the Excel file with the sheets at the file path as specified.
- Lastly out of the BUD: set an email tool to attach the file from the same path and compose the email as you would like. I use a Summarize tool to make sure there's only one record set (the email tool sends an email for each record it receives).
In the attached workflow, I was able to successfully send myself an email with an Excel file attached which included two named sheets of data. Check the attached workflow out and let me know if you have any questions.
Hi @czjames87
- Are you looking to send two csv files, or combine those two csv tables into one Excel file with two sheets? Multiple attachments can be made to an email.
- Are you having trouble preparing the data/file(s) or the email?
I'm looking to combine two csv tables into one excel file with two sheets. Currently the email is being generated with the attachment has all the data on one sheet instead of being separated into two.
