DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
dnat
Participant



Joined: 06 Sep 2007
Posts: 200

Points: 1864

Post Posted: Fri Apr 06, 2018 1:28 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I have data like this.

Code:
key, start, end
1,1,100
1,80,140
2,200,300
4,250,300

Here I am looking to reject/capture the first two records where there is an overlap. i.e for the same key, the end should not fall between the start and end of the other record(with the same key). and the start should not fall between the start and end of the other record. basically the overlapping records.

I tried using Range lookup, withe input and reference as the same but i am not able to apply both the conditions.

The condition should be start not between start and end OR end not between start and end.

Range lookup is only able to do AND condition.

Is there a way to do that?

Thanks!
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54166
Location: Sydney, Australia
Points: 293772

Post Posted: Fri Apr 06, 2018 7:50 pm Reply with quote    Back to top    

Use a Transformer stage, with sorted data, and stage variables to remember the previous record. Effect your test using output link constraint expression(s). If you really need to capture the rej ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours