Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • How do I compare the total record count of the same 4 feature classes in 2 file geodatabases and then send a notification email if the counts are exactly the same?

I'm currently using a file gdb reader, a statistics calculator to get the total counts, attribute manager to create fields called Today_Count and Yesterday_Count and then the conditional value in attribute manager to try and compare the two counts and return a 1 if they're exactly the same but I can't seem to get the comparison to happen. Also how do I set this up so that if the counts are exactly same I can send out an email notification?

Screenshot 2023-06-02 144201Screenshot 2023-06-02 144324Screenshot 2023-06-02 144411Screenshot 2023-06-02 144302

You need to get the two rows in one to make the comparison. One way to do this is to use an Aggregator. Merge attributes. Then you can use a tester to test if Today_Count = Yesterday_Count.

You need to get the two rows in one to make the comparison. One way to do this is to use an Aggregator. Merge attributes. Then you can use a tester to test if Today_Count = Yesterday_Count.

Thanks nielsgerrits!

Reply


Community Stats

30,117
Posts
114,317
Replies
37,748
Members
Terms & ConditionsCookie settings
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.