on 04-26-2011 8:58 AM
Hello Experts,
I have one Standart DSO. This is load by two Datasources. I load the first Data inside the DSO, it is ok.
The second Source should add into the Key an other key.
Exam:
1. Load
Key 2.Key
AAA BLANK
2. Load should add 555 into the AAA
Key 2. Key
AAA 555
Can someone ive me Information about this, how can I do that.
Regards
Mo
Hi Mojito,
Why you have two key? According to given information, you only need one key. If you want to update second key(in this scenerio should not be key), you should remove it from key fields. So you can update this field.
Regards,
Akturk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mo,
Remove the Keyfield2 from the DSO & add it to Datafield. So no you will have only 1 keyfield.
So when you load data for the first time it lokks
Key Datafield1
AAA BLANK
When you load the data from 2nf source having datafield1 as 555 & keyfield as AAA, the 1st record loaded will be overwritten & it looks like below as per your requirement:
Key Datafield1
AAA 555
Hope it helps!
Regards,
Pavan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
as long as both fields are in the key, you can't.
if you want to overwrite one field, you need to get it out of the key.
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 |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.