Grouping of Related Data
Posted: Thu Mar 24, 2005 10:28 pm
Hi,
I've a following situation.
I'm supposed to do a look up on 1 dataset (primary i/p) and a oracle table (reference link) based on 5 columns.
1. A
2. B
3. Date1
4. Date2
5. C
Now the criteria is if there is a match found on colum A, B and C, it meets the initial criteria. And from the output of this I'm supposed to pick up the earliest date(Date1) among the related group(the records which have a match for column A, B, C are relared). So in short there will be 1 earliest Date1 for each group & there can be several groups.
Can this task be done using look up ? Or shd I go for some other stages?
Thanks in advance.
Bilwakunj
I've a following situation.
I'm supposed to do a look up on 1 dataset (primary i/p) and a oracle table (reference link) based on 5 columns.
1. A
2. B
3. Date1
4. Date2
5. C
Now the criteria is if there is a match found on colum A, B and C, it meets the initial criteria. And from the output of this I'm supposed to pick up the earliest date(Date1) among the related group(the records which have a match for column A, B, C are relared). So in short there will be 1 earliest Date1 for each group & there can be several groups.
Can this task be done using look up ? Or shd I go for some other stages?
Thanks in advance.
Bilwakunj