Joining 3 Data Sources with a Time Condition - Followup

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:

Same as earlier, except a repeat Car 1

Same as earlier, except a repeat Car 2

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!