Hi all,
I am trying to range look up..on the reference link..
My input source column is updatetimestamp field looking up between mintimestamp and maxtimstamp fields in the reference getting the datadate value..
Range expression is as below.. the job is running but not correctly the datadate value is same for all input.updatetimestamp field values..
input.updatetimestamp >= ref.mintimestamp and
input.updatetimestamp < ref.maxtimestamp
did put peek stage and in the peek output input value is changing for rows but the ref values mintime and maxtime is same for all the rows.. so we are getting one datadate values for all the rows..
Anythoughts.. , please
Range look up for timestamp fields.
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Re: Range look up for timestamp fields.
Below is peek o/p
Peek_422,0: MINIMUM_TIMESTAMP:2004-01-18 15:12:37 MAXIMUM_TIMESTAMP:2004-01-21 11:58:13 UPDATE_TIMESTAMP:2013-07-02 01:51:08.028874
Peek_422,1: MINIMUM_TIMESTAMP:2004-01-18 15:12:37 MAXIMUM_TIMESTAMP:2004-01-21 11:58:13 UPDATE_TIMESTAMP:2013-07-02 01:51:08.028874
Peek_422,0: MINIMUM_TIMESTAMP:2004-01-18 15:12:37 MAXIMUM_TIMESTAMP:2004-01-21 11:58:13 UPDATE_TIMESTAMP:2013-07-13 04:26:58.472317
Peek_422,0: MINIMUM_TIMESTAMP:2004-01-18 15:12:37 MAXIMUM_TIMESTAMP:2004-01-21 11:58:13 UPDATE_TIMESTAMP:2013-07-13 04:26:58.472317
Peek_422,0: MINIMUM_TIMESTAMP:2004-01-18 15:12:37 MAXIMUM_TIMESTAMP:2004-01-21 11:58:13 UPDATE_TIMESTAMP:2013-07-02 01:51:08.028874
Peek_422,1: MINIMUM_TIMESTAMP:2004-01-18 15:12:37 MAXIMUM_TIMESTAMP:2004-01-21 11:58:13 UPDATE_TIMESTAMP:2013-07-02 01:51:08.028874
Peek_422,0: MINIMUM_TIMESTAMP:2004-01-18 15:12:37 MAXIMUM_TIMESTAMP:2004-01-21 11:58:13 UPDATE_TIMESTAMP:2013-07-13 04:26:58.472317
Peek_422,0: MINIMUM_TIMESTAMP:2004-01-18 15:12:37 MAXIMUM_TIMESTAMP:2004-01-21 11:58:13 UPDATE_TIMESTAMP:2013-07-13 04:26:58.472317
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm