Skip to main content
  • EN

Hi,

 

I am using the attribute creator to populate a new field. I want to fill in the blank rows with the previous master property number from the master prop no field. I have enabled the adjacent features but no matter what I try it still only populates just the 1 record after a value and not all the blanks. I thought I would only need 1 based on what I’ve found on the forums.

What am I doing wrong here?

I also tried to do that same thing via the attribute manager but get the same result.

The end result would also have row 3 (FME row id not the xlsx one) with ‘932590’ and row 6 with ‘933123’ and rows 9-11 with ‘933796’ etc with the number of blank rows varying from 1 to potentially hundreds.

The settings I have for the transformers are below.

I am using FME 2022.2.

 

Thank you!

 

Belinda

Hi ​@bkerr This question just came up and ​@takashi caught the issue. In the first case: If there is a value then No Action. Else -1 

Fill in adjacent empty values in table is not working as I expect? | Community

Hope that helps!

Hi ​@crutledge. I did see that post but in my case I’m populating a new field so I need it to take the value over rather than do no action. I did try that but it just leaves me with ‘missing’ values for that top row instead. 

 

Ah ​@bkerr then you will want the part of the solution that I proposed (that didn’t work there but I think works here).

In Your case .test is .master_prop_no_calc

That work?

HI ​@bkerr ,

If “master_prop_no_calc” is a new attribute that will be created in the AttributeCreator, expose its name with AttributeExposer beforehand.

Then, in the AttributeCreator, I think this conditional value setting works as expected.

If master prop. no. has a value then master prop.no.
Else featuref-1].master_prop_no_calc

Hi ​@takashi ,

 

That did the trick. I was getting the featuret-1] value from the wrong field. I thought it would of worked from the other but it doesnt. Swapping it to the newly calculated field resolved the issue. Thank you!

​@bkerr Good stuff. Glad you got it working! It’s always those little things. :D

Community Stats

31,358
Posts
118,954
Replies
38,988
Members

Latest FME

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.