on 11-24-2016 11:30 AM
Hi Experts,
This is a scenario which I have often come across while updating Std DSO where the source have multiple lines items against the particular set of key and we need to pick the first records or last record or record which has values. To elaborate your with an example of source data:
KEY1 KEY2 FIELD1 FIELD2
34578 AA 10 USD
34578 AA X 10 USD
34578 AA 10 USD
Expected Result in Std DSO:
KEY1 KEY2 FIELD1 FIELD2
34578 AA X 30 USD
but I get FIELD1 as blank
Can someone suggest how we can handle such scenario? If field routine is the answer can someone provide me example of the code please.
Regards
Ani
you could use semantic grouping on the key. so all the records with the same key are in the same package. in the start routine you can filter the one you need.
M.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.