Need to find more than one output using render tool and send those output through mail

[Indradip22]

Hi Alteryx Community,

I am stuck with one problem where I need to produce multiple output through render tool. I have one set of data. From this data set, I need to produce different data sets based on company name. And also, I need to send this output through mail. I have attached my input file and output also. Can anyone help me to achieve my desire output? 

[gawa]

hi @Indradip22 

When creating table, specify "Group" option(in this case it is 'company'), then report will be split into each company.

If you don't wanna company name, uncheck it in Table tool, and add company name on header by Text tool...then output by Rendering tool.

One tips in rendering tool. Please specify "Choose a Specific Output File" and "Group Data into Separate Reports" to split report into multiple file, otherwise with default option(Temporary file),  "Group Data into Separate Reports" can't be selected.

 

[Indradip22]

@gawa Thank you for quick answer. I will check and will tell that is it working or not.

[Indradip22]

Hi @gawa your output is okay but I am looking for something else. Because in my output there are two section, one is for company name and it's number another one is that data part. Can you help me how can I do this? I have attached my workflow below. Can you please modify my workflow?

[gawa]

Hi, @Indradip22 

I just modified your workflow as you wish. Please refer to attached workflow, and if it is OK, please accept my post as a solution. Thank you!

[Indradip22]

 Hi @gawa can I get like this for upper part of my report?

[gawa · Accepted solution]

@Indradip22 

Then, you can transpose data for upper part. See attached workflow for you ready reference.

In general, it is important to set "Group by" option properly so as to create split report. Good luck!

[Indradip22]

Hi @gawa thank you so much to help me for reaching to my desired output.