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
Astéroïde

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 RÉPONSES 7
binuacs
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
Astéroïde

@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
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
Astéroïde

@binuacs Custom size also impacting to both tab.

binuacs
Arcturus

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

Srawat
Astéroïde

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

binuacs
Arcturus

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

Étiquettes