Forward fill in pipeline builder

[robind]

I have some missing values in my data in pipeline builder. I would like to forward fill these values, eg. for column “Country”
USA
null
UK
needs to become
USA
USA
UK

I cant find a way to do this via standard transforms (Generate also struggled). Maybe a python function, but how? Does a python function only operate on a single row level?

[LukaszF]

Hi @robind,

Here, I suggest utilizing the “window” function of “sorted” type. It will allow you to essentially forward fill your data as instructed. You just need to specify a column that you can sort by, to ensure the right order of your values. Screenshot below demonstrates possible configuration for your case:

Hope this helps!

[robind]

That worked, thank you!