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?
Best Answer
Try a group by in statistics calculator as fme_feature type, you need to expose the fme feature type from the reader.