Alteryx Designer Desktop Discussions

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

Two Render tool Data in One Excel file in different tab.

Srawat
8 - Asteroid

Hi,

 

Can anyone help me to get data in one excel file in different tab from two render tools?

 

Srawat_0-1676734413332.png

 

Thanks,

Rajeev

 

7 REPLIES 7
binuacs
20 - Arcturus

@Srawat Attaching a sample workflow which writes the output in different tabs in an excel using the render tool

binuacs_0-1676736173595.png

 

Srawat
8 - Asteroid

@binuacs Thanks, I did the same however when I creating the file there is two tab one is invoice and another is data  and in data tab data is not coming in proper format. I tried changing the paper size however impacting in both the tab. there is the screen shot. SAP data to be formatted. Please help.

 

Srawat_0-1676736740199.png

 

Srawat_1-1676736809792.png

 Thanks.

 

 

 

binuacs
20 - Arcturus

@Srawat If you change the paper size it will affect both tabs. Change the paper size to custom and increase the size to properly see the data

Srawat
8 - Asteroid

@binuacs Custom size also impacting to both tab.

binuacs
20 - Arcturus

@Srawat Changing paper size in one tab will impact all the tabs

Srawat
8 - Asteroid

@binuacs  any other way to get the things as i needed.

binuacs
20 - Arcturus

@Srawat One option is to write the output directly in the formatted excel output instead of using the render tool

Labels