New column - applying single value to all rows in a new column

Question

Hello - in the image below, I'm trying to add a new "weighted average" column and I want the .267544 to show on each row. Ideally, row 1 with the "nulls" goes away and row 1 starts on row 2 in image below and I see the weighted average repeated all the way down. Hope this makes sense.

OllieClarke · Accepted Answer

Hi @dottman use a filter tool to separate the row where [Weighted Average] is not null.
You can then use the Append Fields tool to attach that row to all the records coming out of the false output of the filter.
Use the select tool embedded in the Append Fields tool to clean up the columns, so there's only 1 of each :)

Hope that helps,

Ollie