Lookupstage Match/Rejects

kollurianu · Post by **kollurianu** » Mon Sep 13, 2010 12:57 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 13, 2010 3:07 pm

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".

ray.wurlod · Post by **ray.wurlod** » Mon Sep 13, 2010 3:10 pm

Please delete your duplicate thread before anyone posts to it.