We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Reporting and E-mail

ManuelRodrigues
8 - Asteroid

Hi,

 

I have an Alteryx workflow that generates reports to excel and i was wondering if i can do some further enhancement to automate the process further?

 

1. I want the report that it currently generates in excel to add a front sheet and format the data in a neat tabular form. Also would like to dynamically change that front sheet date each qtr

   

    Example:

 

AT1.1.JPG

 

 

 

2. Once this is done i have a list of business units and also a distribution list that i need to send the emails to.

 

Thanks in advance for your help.

2 REPLIES 2
Amit_G_Limbasia
9 - Comet

Dear @ManuelRodrigues,

 

For your use case you can use formula tool to create a column with SheetName like I have created using formula tool 
Formula : 
DateTimeFormat(DateTimeNow(),"%d-%b-%y")

 

Column Output : 06-Feb-24

Then Use ouput Data tool : 

Use following configuration which is highlighted 
And you can see in result window Sheet with Particular name is created successfully

 

 

Capture.JPG

SGolnik
11 - Bolide
11 - Bolide

To make a nicely formatted output, like in your screen shots, I would either write to an excel template that contains the formatting or use the reporting tools to build the sheet. To do dynamic sheet names using the render tool instead of output, see this link: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Render-table-to-dynamic-file-s...

To do the email, you would use the email tool. The email tool is always the last tool run within a workflow. Here is a great knowledge base article on the email tool: https://community.alteryx.com/t5/Engine-Works/Reporting-in-Alteryx-Sending-Emails-with-Attachments/b... 

Labels
Top Solution Authors