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
And, this is what I want (with grey-color being the items I want to automate with FME)
:
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.)
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:
See also here: https://engage.safe.com/blog/2017/08/adjacentfeatureattributes-evangelist166/