I'm trying to create a count that changes whenever it sees an empty row in a dataset. For example, I have the first 3 columns and would like to create a column similar to Test2 (see image below) that has a new count whenever there is an empty value in Test in the preceding row. Any ideas would be greatly appreciated!
AttributeCreators have the option to "Enable Adjacent Feature Attributes" which allows you to use the values of attributes which precede or follow the current feature. I have a working example for you that does what you describe here. The biggest problem here is that there can be multiple features that can have no value for the "Test" attribute which meant that I needed an extra AttributeCreator to get the desired result.
AttributeCreators have the option to "Enable Adjacent Feature Attributes" which allows you to use the values of attributes which precede or follow the current feature. I have a working example for you that does what you describe here. The biggest problem here is that there can be multiple features that can have no value for the "Test" attribute which meant that I needed an extra AttributeCreator to get the desired result.
Thank you! I was able to use the example you provided with a couple changes to deal with missing/null to get it to work with my full dataset. I appreciate the help!