Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

Alteryx Designer Desktop Discussions

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

Multiple Tables in a single sheet in Excel with Same formatting style

sridharthemass
7 - Meteor

Hi All,

    Could someone please help in creating two different tables in a single sheet in excel with same formatting style and colour as provided below in the screenshot:

 

sridharthemass_0-1603967970613.png

Unable to bring in the total in row number 3..

 

4 REPLIES 4
Qiu
21 - Polaris
21 - Polaris

@sridharthemass 
Applying Table Tool to each of the tables in Excel then Join them by position might be the solution here.

Table.PNG

AkimasaKajitani
17 - Castor
17 - Castor

We can combine the Report type field, so I adjust the adding the space table. 

 

AkimasaKajitani_0-1603974754718.png

 

Result is below.

AkimasaKajitani_1-1603974986346.png

 

sridharthemass
7 - Meteor

@AkimasaKajitani This really helps and thanks for your sample workflow, just one small query - is it possible to put that output of render tool created to an new tab in existing excel file present ? can you please help me in modifying it the sampleWF.yxmd sent..

AkimasaKajitani
17 - Castor
17 - Castor

@sridharthemass I'm glad to helping.

 

I reply to your another question.

Render tool always overwrite the file, so we can't add the new table to existing excel file .

 

But If you open the existing file, reformat and make another new table, you can output a single Excel file that have the multiple sheets each table. Please refer the below URL.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Using-Reporting-Tools-to-create-Mul...

Labels