Skip to main content
  • EN
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

 

 
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
Perfect, I'd never used those options within the AttributeCreator before

Reply


Community Stats

30,108
Posts
114,295
Replies
37,743
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.