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 |
