Hi All,
Purchase Order Header Details are to be sent to target file...
Only One Unique Document Number should be sent along with the Vendor..
Say I am getting from Source like this
DOCNUM VENDOR
12356 ABC LTD
12356 ABC LTD
12357 XYZ Co
12589 SHELL CO
12589 SHELL CO
12589 SHELL CO
out put should file be like this
12356 ABC LTD
12357 XYZ Co
12589 SHELL CO
My structure is like this
source -->
Header (0....unbounded)
DOCNUM
Vendor
Target -->
Supplier (0...unbounded)
Order
Vendor
Please suggest me how to go...
I have successfully done this with UDF ... but can i do this with standard Functions..
Thanks and Regards,
sridhar reddy