Skip to main content
Solved

expand and contract rows and sum total at the bottom in excel

  • October 30, 2015
  • 2 replies
  • 41 views
gisbradokla
Enthusiast
Forum|alt.badge.img+17
I am using statistics calculator to fill in the total number of features from a datasource.

 

  1. I want to expand and contract that list in excel dependent on non zero.
  2. I also want a grand total at the bottom to be just below the last row.

 

Do I need to get the max number of possible rows to use in a parameter?

 

Do I need to create a parameter to count those rows and make that parameter the location +1 of my grand total?

Best answer by fmelizard

Sounds like you could just route all the data features to your Excel output, and then route the summary feature coming out of the stats calculator there too. The stats summary feature will always come out last so will be the last row. You'd have to just name the "count" attribute to be whatever you named the column in Excel where you want that to go.

 

 

If the count was 0, then either the stats calculator won't output anything (because nothing came in) or you could use a Tester afterwards to throw out the record if it was 0. I believe the former.

 

 

Not sure what you meant by point #1 -- expand and contract the list.
@gisbradokla
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • Best Answer
  • October 31, 2015
Sounds like you could just route all the data features to your Excel output, and then route the summary feature coming out of the stats calculator there too. The stats summary feature will always come out last so will be the last row. You'd have to just name the "count" attribute to be whatever you named the column in Excel where you want that to go.

 

 

If the count was 0, then either the stats calculator won't output anything (because nothing came in) or you could use a Tester afterwards to throw out the record if it was 0. I believe the former.

 

 

Not sure what you meant by point #1 -- expand and contract the list.
takashi
Celebrity
  • takashiCelebrity
  • October 31, 2015
Hi,

 

 

I think the grand total row from the Summary port of the StatisticsCalculator will be written at last naturally, in most cases.

 

However, it may not be guaranteed if you perform some operations for the data rows using some group-based (blocking) transformers in parallel with the StatisticsCalculator. Is there such a situation?

 

 

Takashi
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.