Skip to main content
  • EN

Hi FME Community,

 

I've been sent a spreadsheet with a series of rent entries. The name of the property, the dates and rent are the fields which are important.

 

For each entry, which is a single line per rent payment, there may be an increase in the amount. This can be after 1 line, or 20. Basically, I need to only keep the entries which show an increase in rent amounts.

 

Trying to find these entries and automate them seemed simple at first - but has stumped me.

 

If anyone has any ideas, I'll be very grateful.

Thank you

Hi Joe! I attached a workspace that uses attribute creator with adjacent features to solve how I interpreted your question. It looks for the previous row (after sorting the initial input), checks that it's the same property ID(or name, in your case) and if the rent_paid is greater than the previous months rent_paid. If so, it sents rent_increased to 1, otherwise it leaves it at 0. It's important to check for the property ID/names being the same too, otherwise you'll get edge effects when the property changes.

 

If you need to restore the original order, a counter before any of this stuff is a good idea. Let me know if I didn't get any aspect of your original question / input data correct, because there's more fun to be had with this stuff (VariableSetter / VariableRetriever especially!) : )

Hi Joe! I attached a workspace that uses attribute creator with adjacent features to solve how I interpreted your question. It looks for the previous row (after sorting the initial input), checks that it's the same property ID(or name, in your case) and if the rent_paid is greater than the previous months rent_paid. If so, it sents rent_increased to 1, otherwise it leaves it at 0. It's important to check for the property ID/names being the same too, otherwise you'll get edge effects when the property changes.

 

If you need to restore the original order, a counter before any of this stuff is a good idea. Let me know if I didn't get any aspect of your original question / input data correct, because there's more fun to be had with this stuff (VariableSetter / VariableRetriever especially!) : )

I couldn't upload the data in the same post, so... here's the data my example uses!

I couldn't upload the data in the same post, so... here's the data my example uses!

Hi fhilding, thank you so much! I was going down the adjacent feature route and you....well you just hit the nail on the head.

You absolute star, thank you

I couldn't upload the data in the same post, so... here's the data my example uses!

All good! Happy change-hunting :)

Reply


Community Stats

30,186
Posts
114,573
Replies
37,852
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.