Output several sheets using Reporting Tools

[vijaylnyadav]

Hi,

I want to output a single excel file with several sheets using the reporting tools.

Please consider the following data.

Roll Number	Section	Result
1	A	Pass
2	A	Fail
3	A	Average
1	B	Pass
2	B	Fail
3	B	Average
1	C	Pass
2	C	Fail
3	C	Average

I want section in different sheets and one excel file as section.

Pass - Green
Fail - Red

Average - Yellow

I am getting one excel file using output tool, action tool and file browse tool.

But I am not knowing how to do it with reporting tool,

Can anyone assist me on ths.

[Qiu]

@vijaylnyadav 
Then I have go back to my first post.

---

As far I know, creating multiple sheets Excel file with specified Sheet Names with render tool is big challenge.

---

[vijaylnyadav]

@Qiu if sheet names is not possible then what about the selecting the output folder rather than output file using the folder browse and action tool.

???

[messi007]

@vijaylnyadav,

In this case and as @Qiu said it's a big challenge with render tool.

I suggest you to create one file per sheet store them in a folder then union them together in one file.

Hope this helps,

Regards,

[vijaylnyadav]

Hi, @Qiu @messi007

Can you please provide a sample workflow how i can achieve this.

[vijaylnyadav · Accepted solution]

Hi,

Please refer the link for the solution.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Change-Excel-sheet-name-in-file-genera...

[Qiu]

@vijaylnyadav 
It seems you found solution.

Sorry did not make it in time.