Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hello,
Use this:
Load
Date,
if( isnull( Stage ), Peek('NewStage'), Stage ) as NewStage
From ...
Regards