Forum Discussion
Add Column previsus date
Good afternoon people. I have a table of this type
| Shipment N | Tool | Date |
| 9459 | A | 15/08/2023 |
| 9459 | B | 15/08/2023 |
| 9459 | C | 15/08/2023 |
| 9435 | A | 03/08/2023 |
| 9435 | C | 03/08/2023 |
| 9435 | D | 03/08/2023 |
| 9435 | E | 03/08/2023 |
| 9435 | F | 03/08/2023 |
| 9434 | D | 02/08/2023 |
| 9434 | F | 02/08/2023 |
| 9410 | A | 12/07/2023 |
| 9410 | D | 12/07/2023 |
| 9410 | R | 12/07/2023 |
I need your help. I want to add a column with the previous shipment date and another one with the previous shipment number.
| Shipment N | Tool | Date | Previus Date Ship | Previus Ship |
| 9459 | A | 15/08/2023 | 03/08/2023 | 9435 |
| 9459 | B | 15/08/2023 | - | - |
| 9459 | C | 15/08/2023 | 03/08/2023 | 9435 |
| 9435 | A | 03/08/2023 | 12/07/2023 | 9410 |
| 9435 | C | 03/08/2023 | - | - |
| 9435 | D | 03/08/2023 | 02/08/2023 | 9434 |
| 9435 | E | 03/08/2023 | - | - |
| 9435 | F | 03/08/2023 | 02/08/2023 | 9434 |
| 9434 | D | 02/08/2023 | 12/07/2023 | 9410 |
| 9434 | F | 02/08/2023 | - | - |
| 9410 | A | 12/07/2023 | - | - |
| 9410 | D | 12/07/2023 | - | - |
| 9410 | R | 12/07/2023 | - | - |
