Update table according to the date less than or equal to the reference fileHi all,
I have 2 tables where the dtA is my original file and dtB is my reference file. What I would wanted to do is to have dtA be updated according to the date less than or equal to the reference file.
For example,
Table dtA
| Date | Model | Qty |
| 06/24/2023 | A | 23 |
| 06/30/2023 | A | 25 |
| 07/01/2023 | A | 34 |
| 07/05/2023 | A | 50 |
Table dtB
| Date | Model | Ref |
| 06/01/2023 | A | 100 |
| 07/01/2023 | A | 150 |
After updating dtA, the table should look like this
| Date | Model | Qty | Ref |
| 06/24/2023 | A | 23 | 100 |
| 06/30/2023 | A | 25 | 100 |
| 07/01/2023 | A | 34 | 150 |
| 07/05/2023 | A | 50 | |
Is this possible? Please help
Automation and Scripting
