Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am reading around 120 spatial tables in FME. I would like to export a spreadsheet or CSV using FME that contains the feature name (table name) and the number of records in that table.

So far, I've tried linking a counter to each feature type and the Statistics Calculator to get the max value for the counter. I then try to write the CSV with only fme_feature_type and max attributes. I'm getting the max value output okay, but the fme_feature_type is not writing to the CSV.

Any ideas? Also, do I need to add a counter to all the tables separately? Or can I connect them all to a counter and then split it up somehow by fme_feature_type?

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

Try a group by in statistics calculator as fme_feature type, you need to expose the fme feature type from the reader

share|improve this answer
    
Yes, in which case the "Total Count" output is what will contain your result. But the Counter method is equally as valid. –  Mark Ireland Mar 4 '13 at 16:56
    
I had actually tried this and it was working but not outputting the fme_feature_type, just the count. I tried exposing the attribute but it wasn't working. In the end, I manually added fme_feature_type as a user attribute and it worked, even though I had already added it in the Format Attributes. It's working now and this was the best approach. Thanks. –  Fezter Mar 5 '13 at 0:30
add comment

Not tried this, but it sounds like you should be able to use the Counter transformer and specify your feature_type_name (or fme_feature_type if you haven't renamed it) attribute as the "Counter Name" parameter:

Counter Name

Create separate sequences of numbers to be assigned, either by placing several Counter transformers with each having a different counter name, or by choosing an attribute whose value will be used as the counter name as each feature passes through. (In effect, using an attribute to supply the Counter name is like having a Group By option for the Counter.)

I also found this discussion on FME Community Answers.

share|improve this answer
    
Remember to check the default start number 0, sometimes you might want it to start at 1 or -2 etc depending on your workspace. –  Mapperz Mar 1 '13 at 14:24
    
The default attribute is _count you can use the AttributeRenamer to change that after that transformer. –  Mapperz Mar 1 '13 at 14:26
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.