Hi Friends ,
Doing an extraction of Supplier data based on Invoice data.
so using the condition ap_vend = vd_addr . But this is making me go crazy ! the data file is having duplicate values .
See the scenario below which is happening now.
ap_vend vd_addr
------------ -------------
1 1
1 2
1 3
2 4
3 5
4
4
5
where ap_vend = vd_addr , I am extracting data from vd_mstr as well as ad_mstr .
i.e vd_addr ad_name ad_line1 etc ... are column headers.
when it equals first time ap_vend(1) = vd_addr (1)
-> it gives a record values to vd_addr ad_name ad_line1 etc
when the program runs... n number of times ap_vend value repeats... n number of time duplicates are present in vd_mstr extract file..
i.e vd_addr ad_name ad_line1
1 XXXXXX XXX1
1 XXXXXX XXX1
1 XXXXXX XXX1 - > why because ap_vend has value '1' 3 times.
I need n->1 relation/extraction. i.e after this record
vd_addr ad_name ad_line1
1 XXXXXX XXX1
if again ap_vend =1 = vd_addr then ignore this and compare next...
i.e vd_addr ad_name ad_line1
1 XXXXXX XXX1
2 XXXXXX XXX2
- > should be the data file ...
How this can be achieved. Any ideas ?
Progress Version : 9.1D, MFG/Pro eB2 CHUI
Thanks
Doing an extraction of Supplier data based on Invoice data.
so using the condition ap_vend = vd_addr . But this is making me go crazy ! the data file is having duplicate values .
See the scenario below which is happening now.
ap_vend vd_addr
------------ -------------
1 1
1 2
1 3
2 4
3 5
4
4
5
where ap_vend = vd_addr , I am extracting data from vd_mstr as well as ad_mstr .
i.e vd_addr ad_name ad_line1 etc ... are column headers.
when it equals first time ap_vend(1) = vd_addr (1)
-> it gives a record values to vd_addr ad_name ad_line1 etc
when the program runs... n number of times ap_vend value repeats... n number of time duplicates are present in vd_mstr extract file..
i.e vd_addr ad_name ad_line1
1 XXXXXX XXX1
1 XXXXXX XXX1
1 XXXXXX XXX1 - > why because ap_vend has value '1' 3 times.
I need n->1 relation/extraction. i.e after this record
vd_addr ad_name ad_line1
1 XXXXXX XXX1
if again ap_vend =1 = vd_addr then ignore this and compare next...
i.e vd_addr ad_name ad_line1
1 XXXXXX XXX1
2 XXXXXX XXX2
- > should be the data file ...
How this can be achieved. Any ideas ?
Progress Version : 9.1D, MFG/Pro eB2 CHUI
Thanks