Question:
Hi,
is it possible to aggregate the data in the data target say by some ID, if i have for example the following content:
ID; PAR1; PAR2;
-----------------------
1; A; ;
1; ; B;
and i'd like to have it:
ID; PAR1; PAR2;
-----------------------
1; A; B;
Thanks a lot!
Leena
Answer:
YEs : create an ODS with "ID" in the key and "PAR1" and "PAR2" as datafields
Answer:
I tried it, but it doesn't aggregate in the way i need:
it aggregates the initial table:
id; par1; par2;
1; A; ;
1; ;B;
this way:
id; par1; par2;
1; ; B;
Answer:
hmmmm, i was ro fast indeed.
Maybe give us some more info first ....
* are par1 and par2 key figures or characteristics
* are these records coming from 1 DataSource? Form which?
Answer:
id; par1; par2;
1; A; ;
1; ;B;
this way:
id; par1; par2;
1; ; B;
This happens because the second record overwrites the first.
i assume par1 and par 2 are chars.
there is no easy way to do it.
You will have to come up with a new design design.
Answer:
I guess you could create two update rules and for the first use the "overwrite" option for par1 and the "no update" option for par2. In the second do the opposite. You would of course need two infosources too. Not a very neat solution but I think it could work?
Regards
Andreas