Skip to main content
Solved

How to fill unmerged cells with values from previous rows?


I have an excel file that does not have any merged cells. Any cell that is left blank is supposed to take the value from the previous row. How do you do that in FME without looping through a list?

 

This is what I have

image.pngAnd, this is what I want (with grey-color being the items I want to automate with FME)

image.png:

 

Best answer by nielsgerrits

In the AttributeCreator, under Advanced, you can Enable Adjacent Feature Attributes which will let you access prior or subsequent features. You can then use conditionals to set attributes, like you would do in Excel. (If A has a value, do nothing. Else, use A from the previous row.)

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

2 replies

nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • August 17, 2023

In the AttributeCreator, under Advanced, you can Enable Adjacent Feature Attributes which will let you access prior or subsequent features. You can then use conditionals to set attributes, like you would do in Excel. (If A has a value, do nothing. Else, use A from the previous row.)


david_r
Celebrity
  • August 17, 2023
nielsgerrits wrote:

In the AttributeCreator, under Advanced, you can Enable Adjacent Feature Attributes which will let you access prior or subsequent features. You can then use conditionals to set attributes, like you would do in Excel. (If A has a value, do nothing. Else, use A from the previous row.)

Exactly, simply adding a screenshot:

imageSee also here: https://engage.safe.com/blog/2017/08/adjacentfeatureattributes-evangelist166/


Reply


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