DSXchange

Hi All,

I need to acheive following logic in my job with lookup stage, sources (source and ref source) are files

Settle Dates are same and
Share Quantity are same and
Mainframe Time Stamp for both records are within a minute and
The first 3 digits of the SS Asset ID for both the records are same.

The value/format in Mainframe Time Stamp field is 8/31/2010 15:41.

Any thoughts greatly appreciated.

Thank you all.

Create a numeric representation of the timestamp as a string (for example 201008311541 and use that in the lookup. Can you be a bit more precise about "within a minute" implies? The granularity of your timestamp is already "minute".