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.
Lookupstage Match/Rejects
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: