Skip to main content
Solved

Keep first feature after change

ebygomm
Influencer
Forum|alt.badge.img+39
A 1 STARTED

 

A 2 IN PROGRESS

 

A 3 IN PROGRESS

 

A 4 PAUSED

 

A 5 IN PROGRESS

 

A 6 IN PROGRESS

 

A 7 COMPLETE

 

A 1 STARTED

 

B 2 IN PROGRESS

 

B 3 IN PROGRESS

 

B 4 IN PROGRESS

 

B 5 COMPLETE

 

 

I have a list of actions which are listed in the order they performed. Sometimes the actions do not result in a change in the attribute  I am interested in, so there are 'duplicate' entries. However I want to keep those duplicates where they appear either side of a status change.

 

 

So in the above examples I'd end up with

 

 

A 1 STARTED

 

A 2 IN PROGRESS

 

A 4 PAUSED

 

A 5 IN PROGRESS

 

A 7 COMPLETE

 

A 1 STARTED

 

B 2 IN PROGRESS

 

B 5 COMPLETE

 

 

I know how to do this in excel but I'm struggling to find a way to repeat it within FME

 

 

Best answer by takashi

Hi,

 

 

I would use an AttributeCreator with the "Enable Adjacent Feature Attributes" option and a Conditional Value to create an attribute which indicates whether the record should be kept. And then, filter the records by testing the attribute value, with a Tester.

 

Assuming that the field name is "status", the AttributeCreator parameters setting looks like this, for example.

 

 

 

Takashi
View original
Did this help you find an answer to your question?
<strong>This post is closed to further activity.</strong><br /> It may be a question with a best answer, an implemented idea, or just a post needing no comment.<br /> If you have a follow-up or related question, please <a href="https://community.safe.com/topic/new">post a new question or idea</a>.<br /> If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

takashi
Evangelist
  • takashiEvangelist
  • Best Answer
  • July 9, 2015
Hi,

 

 

I would use an AttributeCreator with the "Enable Adjacent Feature Attributes" option and a Conditional Value to create an attribute which indicates whether the record should be kept. And then, filter the records by testing the attribute value, with a Tester.

 

Assuming that the field name is "status", the AttributeCreator parameters setting looks like this, for example.

 

 

 

Takashi
ebygomm
Influencer
Forum|alt.badge.img+39
  • ebygommInfluencer
  • Author
  • Influencer
  • July 9, 2015
Perfect, I'd never used those options within the AttributeCreator before

Helpful Members This Week

Community Stats

31,428
Posts
119,163
Replies
39,050
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

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.