Skip to main content
Question

Conditional Counters

  • March 6, 2014
  • 2 replies
  • 55 views
geckosolutions
Contributor
Forum|alt.badge.img+4
Hi,

 

 

     I have a bunch of datasets passing through a counter. The datasets are grouped by area (region) so that each region gets its own count.  This works and I get a nice count of datasets per region  as they are sorted by date.  1 being the most recent dataset.  The problem is.  There is another attribute of [Catagory] and I need it so that every time [Catagory] = Update, the counter does something to freeze the count on the next record to go through.  So the [Catagory=] Update record gets counted like normal, but the next one to go through after it does not increase in count, as follows:

 

 

Dataset 1 - [Catagory] = [], Count = 1

 

Dataset 2 - [Catagory] = [], Count = 2

 

Dataset 3 - [Catagory] = [], Count = 3

 

Dataset 4 - [Catagory] = [Update], Count = 4

 

Dataset 5 - [Catagory] = [], Count = 4

 

Dataset 6 - [Catagory] = [], Count = 5

 

Dataset 7 - [Catagory] = [Update], Count = 6

 

Dataset 8 - [Catagory] = [], Count = 6

 

 

And so on...

 

 

     My mind is already twisting with the logic I have used in this script and hopefully I have simplified the problem for everyone here and I am sure there is a simple combination of transformers that I have just missed due to my drowning in other intricacies of the existing script.

 

 

Thanks for any help,
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

K
Forum|alt.badge.img+4
  • kathyross
  • March 7, 2014
Rather than the Counter, try variables with a Tester and ExpressionEvaluator. e.g.

 

 

VariableRetriever - Retrieve count

 

NullAttributeReplacer - Is count not set yet? If so, default it to one

 

ExpressionEvaluator - Increment count by one

 

Tester - Is the Categiry = Update? If not use a VariableSetter to set the count.

 

takashi
Celebrity
  • takashiCelebrity
  • March 7, 2014
# sorry. I misunderstood your question, deleted my previous post.

 

 

Hi,

 

 

Alternatively, you can use the AttributeCreator with "Multiple Feature Attribute Support" option (FME 2013 SP2 or later).

 

 

1) Add an AttributeExposer to expose the count attribute name, i.e. "_count".

 

 

2) Add an AttributeCreator. Parameter settings are:

 

-----

 

Check "Multiple Feature Attribute Support" option.

 

Number of Prior Features: 1

 

If Attribute is Missing, Null, or Empty: Use Other Value

 

Attribute Replacement Value: 0

 

-----

 

Attribute To Set

 

Attribute Name: _count

 

Value: 2 possible values (conditional value setting)

 

If @Value(feature[-1].Catagoly) = Update Then feature[-1]._count

 

Else @Evaluate(@Value(feature[-1]._count)+1)

 

 

Takashi
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,207
Posts
122,303
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.