Skip to main content
Solved

About the difference of column values initially and count of same column values after filtering.

  • February 23, 2023
  • 2 replies
  • 13 views

Hello all,

I would like to know about the difference between the count of values of one column initially while reading and count of values of the same column after filtering. If difference between the count of values is same then ​we will send an email. so how can we achieve this in fme

Best answer by hkingsbury

flipping the problem around (at least how i'm interpreting it), you're wanting to see if your input data contains a certain value, if that value doesn't exist, then you want to send an email.

 

Simpliest way is to pass you input data through your filtering logic. The right at the end place a nofeaturetester. if a feature comes through you filtering logic, it will come out the output port. If no feature(s) make it through the filtering logic then there will be a blank feature come out the noinput port. you can then tie this into your logic to send an email

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

hkingsbury
Celebrity
Forum|alt.badge.img+63
  • Celebrity
  • 1625 replies
  • Best Answer
  • February 23, 2023

flipping the problem around (at least how i'm interpreting it), you're wanting to see if your input data contains a certain value, if that value doesn't exist, then you want to send an email.

 

Simpliest way is to pass you input data through your filtering logic. The right at the end place a nofeaturetester. if a feature comes through you filtering logic, it will come out the output port. If no feature(s) make it through the filtering logic then there will be a blank feature come out the noinput port. you can then tie this into your logic to send an email


  • Author
  • 4 replies
  • February 24, 2023

flipping the problem around (at least how i'm interpreting it), you're wanting to see if your input data contains a certain value, if that value doesn't exist, then you want to send an email.

 

Simpliest way is to pass you input data through your filtering logic. The right at the end place a nofeaturetester. if a feature comes through you filtering logic, it will come out the output port. If no feature(s) make it through the filtering logic then there will be a blank feature come out the noinput port. you can then tie this into your logic to send an email

Thank you,this has helped me. It solved my issue!​