Fill non - null with existing value

[shreya2811]

Hi All, 

A simple question: 

Have a column with either 1 value say 23-05-2020 OR  null. Want to replace all null values with this non-null value(23-05-...)

I do not want to hard code it as this value will change as per the new input file. I tried multi row but it doesn't do anything. (code below) , All null values are indeed null(checked through data cleansing). 

If isnull([Week Ending]) then [Row-1:Week Ending] else [Week ending] endif

Any help is appreciated. thanks!

[shreya2811]

Yes

[Luke_C]

That doesn't look like the multi-row formula tool. Can you share those configurations please? Have you tried to review the solutions posted to see where the gap might be?

[shreya2811]

no grouping in multi row , yea have looked at some other solutions are tried it but still stuck

[Luke_C · Accepted solution]

@shreya2811 In the top section is there a reason you're updating the REGION field rather than the WEEK_ENDING field? That seems to be the issue. 

[mceleavey]

Hi @shreya2811 ,

I built a tool to do this, is this what you're after? It simply fills in all values from the values above if it's null.

Have a go and let me know.

M.

[shreya2811]

Worked like a charm! That was a very stupid mistake I did, you are awesome Luke, thanks for spending the day fixing this..have a GREAT day, will bother you again as I need to build a complex workflow using these results. Ciao 🙂