Skip to main content
Solved

How to export "Feature output statistics" table for "Features Written" produced in the translation log? It will be nice to have this exported as an excel format. Thank you in advance!


fme
Contributor
Forum|alt.badge.img+7
  • Contributor
How to export "Feature output statistics" table for "Features Written" produced in the translation log? It will be nice to have this exported as an excel format. Thank you in advance!

Best answer by virtualcitymatt

If you switch your normal writer out for a FeatureWriter there is a 'summary' feature which is output which can contain that information. After that you just need to put in an excel writer to get the table formatted however you like.

http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/featurewriter.htm

The FeatureWriter is a super helpful tool

View original
Did this help you find an answer to your question?

5 replies

virtualcitymatt
Celebrity
Forum|alt.badge.img+35
  • Celebrity
  • Best Answer
  • November 10, 2021

If you switch your normal writer out for a FeatureWriter there is a 'summary' feature which is output which can contain that information. After that you just need to put in an excel writer to get the table formatted however you like.

http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/featurewriter.htm

The FeatureWriter is a super helpful tool


fme
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • November 10, 2021

I tried that which was not working out good for me. It basically produces a link to my output and the total number of features written to my FeatureWriter. Instead, I need it to produce a breakdown of the number of features written to my FeatureWriter per excel tab. Thanks, Matt!


virtualcitymatt
Celebrity
Forum|alt.badge.img+35
fme wrote:

I tried that which was not working out good for me. It basically produces a link to my output and the total number of features written to my FeatureWriter. Instead, I need it to produce a breakdown of the number of features written to my FeatureWriter per excel tab. Thanks, Matt!

That info is there it's just inside a list attribute. You can use a list exploder to get these as individual features.

image


ebygomm
Influencer
Forum|alt.badge.img+38
  • Influencer
  • November 10, 2021
fme wrote:

I tried that which was not working out good for me. It basically produces a link to my output and the total number of features written to my FeatureWriter. Instead, I need it to produce a breakdown of the number of features written to my FeatureWriter per excel tab. Thanks, Matt!

The features per sheet information should be available in a list attribute on the summary feature

image


fme
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • November 10, 2021
fme wrote:

I tried that which was not working out good for me. It basically produces a link to my output and the total number of features written to my FeatureWriter. Instead, I need it to produce a breakdown of the number of features written to my FeatureWriter per excel tab. Thanks, Matt!

Thank you @virtualcitymatt​  and @ebygomm​ . I needed the ListExploder between the FeatureWriter and Excel Writer!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings