Blank Non-Significant Values

Tracks one column within a grouping, and blanks another column where the tracking column has no further significant (non-zero) values. It can also perform blanking up to the first non-zero encountered.

Specify a single column against which data is to be grouped. (If grouping with more than one column is required, simply concatenate the required columns into a single "grouping" column.

Specify a second column to be tracked for significant values. The last non-zero value within any group is considered the last significant value in this column for that group.

Specify a third column (which could also be the tracked column) which is to have its value set to Missing from the point at which there are no further significant values in the tracked column.

May 15th 2021 @takbb Brian Bates

Input ports

1. Type: Table
   Data, already sorted into the required order for processing by group

Output ports

1. Type: Table
   Evaluated Data
   Data as supplied but with additional boolean columns FIRST_IN_GROUP and LAST_IN_GROUP