Alteryx Designer Discussions

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

Add total to individual tab in Excel

7 - Meteor

I'm exporting the below table as an Excel file, the data is separated into tabs in the output tool using "Change File/Table Name" option. 

Output.jpg

 

 

 

 

 

 

 

 

 

Is it possible to add a total for each tab, a count of programs? 

 

TimeDateAlternate TitleProgram
06:5007/03/2017ABCProgram1
13:3307/03/2017ABCProgram2
14:1707/03/2017ABCProgram1
06:5007/03/2017XYZProgram1
14:1707/03/2017XYZProgram1
13:3307/03/2017ABCProgram1
13:3307/03/2017XYZProgram1
14:1707/03/2017ABCProgram1
13:3307/03/2017XYZProgram1
12:0007/03/2017ABCProgram1

 

Any help would be appreciated.

7 - Meteor

I think, you can generate total by programme

after that you make a join

If you share a sample of you example, may be  i can help you.

 

7 - Meteor
Attached is the output I'm trying to achieve. The table is getting split at the output tool, how to join the total?
Alteryx Certified Partner
Alteryx Certified Partner

@saravanakumar,

 

Have you considered SUMMARIZE of the table with a GroupBy Program and a Count of Program to produce:  Program & Count?  Then you could JOIN the Count back to the table and have a field of count.

 

I don't quite understand the final requirement for each tab to have a count of programs, but you could add a FORMULA to Alternate Title as:

[Alternate Title] + ' #' + ToString([Count])

This would provide you with ABC #6 as the tab name.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
7 - Meteor

I hope it's help you!

7 - Meteor

Sorry for not being detailed. 

 

Client File is the input file and the sample output is the output I expect to have. Right now I'm splitting the tab using output tool, but i'm unable to add the total counts. 

7 - Meteor

 Take a look at this workflow, , you have only to rename manually the sheet.

16 - Nebula
16 - Nebula

Hey Saravana ( @saravanakumar)

 

You can achieve this using 2 steps:

- Split the flow so that you create the summary (the total row)

- Union it back to your data, but make sure you preserve the ordering and keep the alternative program name (which is important for the file split).

 

2017-08-02_1-07-00.png

 

the output works as you'd expect (screenshot)

2017-08-02_1-11-06.png

 

 

16 - Nebula
16 - Nebula

Hey Saravana ( @saravanakumar)

 

You can achieve this using 2 steps:

- Split the flow so that you create the summary (the total row)

- Union it back to your data, but make sure you preserve the ordering and keep the alternative program name (which is important for the file split).

 

2017-08-02_1-07-00.png

 

the output works as you'd expect (screenshot)

2017-08-02_1-11-06.png

 

 

Labels