Free Trial

Alteryx Designer Desktop Discussions

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

Generate multiple sheets output using group by option in Render tool.

PJ1
6 - Meteoroid

Hi,

 

I am trying to generate multiple sheets using group by option in Render tool, however only one sheet is getting generated for each group.

 

I am attaching the sample workflow as well. 

 

Could anyone please help me here?

 

thanks

10 REPLIES 10
binuacs
21 - Polaris

@PJ1 Something like below

image.png

PJ1
6 - Meteoroid

@binuacs thanks for getting back. I tried the same options as you did and also used the workflow attached by you But, the output is still containing only 1 tab. ideally the Output with File name as AT or BE should contain 3 different sheets i.e., ABC, DEF & GHI. 

binuacs
21 - Polaris

@PJ1 Since you have three file names it should create three files (AT, BE and CZ). Update your render tool settings like below

image.png

PJ1
6 - Meteoroid

Hey @binuacs , yes it produces 3 different files, but the sheet within it has only 1. AT file should contain 3 sheets within it

binuacs
21 - Polaris

@PJ1 I could see three tabs

image.png

PJ1
6 - Meteoroid

@binuacs , it is strange, i used the same workflow attached by you and i still see only 1 tab. 

 

Do you know why?

 

binuacs
21 - Polaris

@PJ1 can you check if the layout/render tools settings are like below or not?

 

image.pngimage.png

 

PJ1
6 - Meteoroid

it is the same setting. and i used the same workflow u shared. still i see only the GHI sheet in AT Output

 

 

 

binuacs
21 - Polaris

@PJ1 Can you turn off the AMP and try

 

image.png

Labels
Top Solution Authors