Need to replace the null values with existing rows in sql

Question

Hi I need to replace the null values with values existing previously for the same Code, as these records are co-ordinates. they might not change over time. So I just need to pull the new dates with values existing in NUmber1, NUmber2 column,

Below an example, ss attached.

grazitti_sapna · Answer

@Ronal_bal, another way of solving this problem in case it occurs for multiple columns.

I hope this helps!

Thanks!

RonalBal_Workflow_20220628.yxmd

philipmannering · Answer

A couple of MultiRow Tools should solve this,

if isnull([Number1]) then [row-1:Number1] else [Number1] endif

And again for the number2. Be sure to group by Code column.

If there is only one filled value, I suppose you might get away with a Running Total Tool too. :)

IraWatt · Answer

Hey @Ronal_bal,

A multi row formula can do this, it can grab values of the row above:

The formula checks for null, if yes grab the row above.

Any questions or issues please ask :)
HTH!
Ira

Workflow.yxmd