Question

Replace empty rows with the value located above it


As shown in the attachment, I am looking to replace the <missing> values with the value located above it. For example, I want rows 44 to 48 to contain the value 2nd st.


2 replies

Badge +22

You can use a conditional along with enable adjacent features on an attributeCreator (If it has a value, keep it, otherwise use the value from the previous feature.)

Userlevel 2
Badge +17

Agree that the combination of the Enable Adjacent Feature Attributes option (1 for Number of Prior Features) and the Conditional Value Setting would be effective.

Alternatively, you can test if the attribute has a value with a Tester, if it has a value then save it into a global variable (VariableSetter), otherwise retrieve the value from the global variable and assign it to the attribute (VariableRetriever).

Reply