Forum Discussion
Solved
Create a Merged Deadline and Service History Table
Hi all - I have 2 tables that I need to connect or merge. One is a list of all my assets (table: Covered Products) under contract with their Name (unique), Contract Start and End Dates, a Service Fre...
How did you generate the last 3 columns of the desired table? I do not see the entries under these columns in the Work Orders table.
Hi,
Based on the 2 tables which you have shared, show the expected result very clearly.
Here would be an example - using the matching Id to find the associated work orders completed against each product name. Then to see if there is a service date within each service period, completed on time.
Hope that Helps
| Product Name | Frequency | Start Date | End Date | Deadline # | Deadline Date | WO Number | Service Date | On Time? |
| SCPN-300001 | 12 | 1/1/2021 | 1/1/2026 | 1 | 31/12/2021 | WO-123456 | 15/12/2021 | Yes |
| SCPN-300001 | 12 | 1/1/2021 | 1/1/2026 | 2 | 31/12/2022 | WO-123457 | 30/11/2022 | Yes |
| SCPN-300001 | 12 | 1/1/2021 | 1/1/2026 | 3 | 31/12/2023 | WO-123458 | 15/01/2024 | No |
| SCPN-300001 | 12 | 1/1/2021 | 1/1/2026 | 4 | 31/12/2024 | WO-123459 | 10/12/2024 | Yes |
| SCPN-300001 | 12 | 1/1/2021 | 1/1/2026 | 5 | 31/12/2025 | WO-123460 |
How did you generate the last 3 columns of the desired table? I do not see the entries under these columns in the Work Orders table.
