Fill rows based on first Row

[MarioS]

Dear QLikers, 

Below is my question, I need to transform the below in the script in think i need to use a peek function, I would appreciate if you can help with its syntax:  Thank you!!!

Input:

Date	Stage
08/12/2019 15:46:00	-
08/12/2019 15:47:00	-
08/12/2019 15:48:00	Navigation
08/12/2019 15:49:00	-
08/12/2019 15:50:00	-
08/12/2019 15:51:00	-
08/12/2019 15:52:00	-
08/12/2019 15:53:00	-
08/12/2019 15:54:00	-
08/12/2019 15:55:00	-
08/12/2019 15:56:00	-
08/12/2019 15:57:00	-
08/12/2019 15:58:00	-
08/12/2019 15:59:00	-
08/12/2019 16:00:00	-
08/12/2019 16:01:00	Maneuvering
08/12/2019 16:02:00	-
08/12/2019 16:03:00	-
08/12/2019 16:04:00	-
08/12/2019 16:05:00	-
08/12/2019 16:06:00	-

Output:

Date	Stage
08/12/2019 15:46:00	-
08/12/2019 15:47:00	-
08/12/2019 15:48:00	Navigation
08/12/2019 15:49:00	Navigation
08/12/2019 15:50:00	Navigation
08/12/2019 15:51:00	Navigation
08/12/2019 15:52:00	Navigation
08/12/2019 15:53:00	Navigation
08/12/2019 15:54:00	Navigation
08/12/2019 15:55:00	Navigation
08/12/2019 15:56:00	Navigation
08/12/2019 15:57:00	Navigation
08/12/2019 15:58:00	Navigation
08/12/2019 15:59:00	Navigation
08/12/2019 16:00:00	Navigation
08/12/2019 16:01:00	Maneuvering
08/12/2019 16:02:00	Maneuvering
08/12/2019 16:03:00	Maneuvering
08/12/2019 16:04:00	Maneuvering
08/12/2019 16:05:00	Maneuvering
08/12/2019 16:06:00	Maneuvering

[Gui_Approbato]

Hello,

Use this:

Load

Date,

if( isnull( Stage ), Peek('NewStage'), Stage ) as NewStage 

From ...

Regards