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

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?

MODEL_DATA.xlsx

Apple.xlsx

Samsung.xlsx

Motorola.xlsx

Designer Cloud

Accepted answers

Gawa

@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!

TPIA_post_alteryx_community_gawa_REV1.yxzp

All comments

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.

Need to find more than one output_gawa.yxzp

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?

TPIA_post_alteryx_community.yxmd

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!

TPIA_post_alteryx_community_modified_by_gawa.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703