Find and replace

[Regina-Dzhuraeva]

Hello Community,

I am trying to find a solution to clear the dataset. Column contains rows most of them started with 2021 and I need to replace it with null. Other lines need to stay as it is Can you help me on that?

Thank you!

Regina

[atcodedog05]

Hi @Regina-Dzhuraeva 

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

[Regina-Dzhuraeva]

Hi @atcodedog05,

As the final solution I want to replace dates with the number that is above

[atcodedog05 · Accepted solution]

Hi @Regina-Dzhuraeva 

Here is how you can do it.

Workflow:

Hope this helps : )