@amitchandak
That looks like what I am looking for. Let me review.
One followup on both this and the previous example:
In this situation, it is possible for my railcar numbers to repeat as we use the same fleet of cars.
So in this example we could have any of numbers 1, 2, 3, or 4 come back later in the data set with later dates.
In the examples you had sent, if you add another row with a repeat Railcar Number, you get an error due to the relationship and if you remove the relationship you get multiple matches that don't meet the time condition
I was hoping that the time condition would prevent the multiple matches.
Is it possible to allow for repeat cars in any data set, and have them only match when they match on number and the time condition (14 days)?
Using the example before:
| Batch Number | Railcar Number | Date |
| A | 1 | 10/1/2025 |
| B | 2 | 10/2/2025 |
| C | 3 | 10/3/2025 |
| D | 4 | 10/4/2025 |
| E | 1 | 12/4/2025 |
Same as earlier, except a repeat Car 1
| Railcar Number | Date |
| 1 | 10/2/2025 |
| 2 | 10/3/2025 |
| 33 | 10/4/2025 |
| 4 | 12/4/2026 |
| 2 | 12/6/2025 |
Same as earlier, except a repeat Car 2
| Batch Number - Batch | Railcar Number - Batch | Date - Batch | Railcar Number - Rail | Date - Rail |
| A | 1 | 10/1/2025 | 1 | 10/2/2025 |
| B | 2 | 10/2/2025 | 2 | 10/3/2025 |
| C | 3 | 10/3/2025 | | |
| | | | 33 | 10/4/2025 |
| D | 4 | 10/4/2025 | | |
| | | | 4 | 12/4/2026 |
| E | 1 | 12/4/2025 | | |
| | | | 2 | 12/6/2025 |
The bottom 2 rows with the repeat cars match with nothing because they are outside the data range
If allowing for repeat cars can be resolved on both data sets, this should resolve the entire project!
