Tolerant match with DateTimeDiff when comparing records from two distinct sources

[emmanuel_varesio]

Dear All,

I would like to join records from two distinct sources based on a DateTime field tolerant match, e.g. if the difference between DateTime from source 1 and 2 is less than 15 seconds, join the records.

I could achieve this DateTime tolerant match with an "append fields" tool followed by a DateTimeDiff function (see attached workflow), but when the number of source 1 & 2 records grows, the resulting dataset size can grow dramatically after the Append tool.

Any help appreciated to find a more efficient way bypassing the "Append Tool".

Best regards,

Emmanuel

[emmanuel_varesio]

Dear All,

First of all I apologize for my long silence, I was out of town and busy on other projects. Although I like your three ways of solving my issue (and I thnak you all for your efforts), I will vote for the macro solution that I find quite tidy and versatile in my global workflow. 

I really appreciate your help that could solve my problem.

Take good care (and once again sorry for my long silence).

E.