Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
21 - Polaris

@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
21 - Polaris

@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
21 - Polaris

@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
21 - Polaris

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

Labels
Top Solution Authors