Skip to main content
Solved

Count Value occurrence based on certain attributes

dberger106
Participant

Hi Guys

I am trying to count the occurrence of a value across a large number of attributes. All the attributes have a different name, however they all have "_SIG" in their name (a value that rates significance). Ie ENVIA_SIG, WATRF_SIG etc. There are heaps of them and I want a way to just test those attributes using a wildcard of sorts.

Basically I would like to use a tester to test for the existence of the number 5 in all attributes that end with _SIG. However in the tester (or Test Filter) I have to manually add each of those attributes which is not realistic as there are over 50 of those attributes.

Any suggestions would be greatly appreciated!

Thank you

Dominique

 

Best answer by ebygomm

If you just want to be able to filter out features that have a 5 in any one of the attributes containing SIG you could use a ListExpression populator to put all the values of Attributes that have SIG in the name into a list then use a ListSearcher to search the list for the number 5

 

You could also use an AttributeValidator, this will let you select all the attributes to validate against the same rule (but does mean you have to select them, so not as dynamic as the above solution) - and you have to check for not 5 ( [^5] ) so that any feature containing 5 will come out the failed port

 

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

3 replies

ebygomm
Influencer
Forum|alt.badge.img+38
  • ebygommInfluencer
  • Influencer
  • Best Answer
  • August 2, 2019

If you just want to be able to filter out features that have a 5 in any one of the attributes containing SIG you could use a ListExpression populator to put all the values of Attributes that have SIG in the name into a list then use a ListSearcher to search the list for the number 5

 

You could also use an AttributeValidator, this will let you select all the attributes to validate against the same rule (but does mean you have to select them, so not as dynamic as the above solution) - and you have to check for not 5 ( [^5] ) so that any feature containing 5 will come out the failed port

 

dberger106
Participant
  • dberger106Participant
  • Author
  • Participant
  • August 4, 2019
ebygomm wrote:

If you just want to be able to filter out features that have a 5 in any one of the attributes containing SIG you could use a ListExpression populator to put all the values of Attributes that have SIG in the name into a list then use a ListSearcher to search the list for the number 5

 

You could also use an AttributeValidator, this will let you select all the attributes to validate against the same rule (but does mean you have to select them, so not as dynamic as the above solution) - and you have to check for not 5 ( [^5] ) so that any feature containing 5 will come out the failed port

 

Thanks heaps for your reply @egomm! The ListExpressionPopulator and ListSearcher are very fast options! I think I am getting closer to my required result. I now have a list of attributes and I can search for the number 5 with the ListSearcher, however I would like to count how many times the number five is in that list. Do you know a way I could search a list and count how many times a certain value is found?

Thanks again

dberger106
Participant
  • dberger106Participant
  • Author
  • Participant
  • August 5, 2019
dberger106 wrote:

Thanks heaps for your reply @egomm! The ListExpressionPopulator and ListSearcher are very fast options! I think I am getting closer to my required result. I now have a list of attributes and I can search for the number 5 with the ListSearcher, however I would like to count how many times the number five is in that list. Do you know a way I could search a list and count how many times a certain value is found?

Thanks again

So managed to answer my own question here - @egomm set me on the right path (thank you) and I just added in a ListHistogrammar, another ListSearcher (to find the list element that had the count of the value 5) and then an attribute creator that use the list_index to pull back the count. Then repeat for all other values I want to summarize.

 

 

Reply


Helpful Members This Week

Community Stats

31,340
Posts
118,848
Replies
38,925
Members

Latest FME

Terms & ConditionsCookie settings

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
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.