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.
Is it possible to add a total for each tab, a count of programs?
Time | Date | Alternate Title | Program |
06:50 | 07/03/2017 | ABC | Program1 |
13:33 | 07/03/2017 | ABC | Program2 |
14:17 | 07/03/2017 | ABC | Program1 |
06:50 | 07/03/2017 | XYZ | Program1 |
14:17 | 07/03/2017 | XYZ | Program1 |
13:33 | 07/03/2017 | ABC | Program1 |
13:33 | 07/03/2017 | XYZ | Program1 |
14:17 | 07/03/2017 | ABC | Program1 |
13:33 | 07/03/2017 | XYZ | Program1 |
12:00 | 07/03/2017 | ABC | Program1 |
Any help would be appreciated.
Solucionado! Ir para Solução.
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.
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
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).
the output works as you'd expect (screenshot)
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).
the output works as you'd expect (screenshot)