Please take a look at this scenario.
I have 3 records coming from source system.
key dateid startdate enddate
c 1 d1 d2
c 2 d3 d4
c 3 d5 d6
i need to populate these 3 records as one into the infoobject based on dateid.
(dateid =1 then kf1=d1,kf2=d2;dateid =2 kf3=d3,kf3=d4 dateid = 3 kf1=d5,kf2=d6)
i added 6 key figures ( kf1 kf2 kf3 kf4 kf5 kf6) as attributes to infoobject.The final
record should look like the below one.
key kf1 kf2 kf3 kf4 kf5 kf6
c d1 d2 d3 d4 d5 d6
Could you pls give me some thoughts on how to do this in a better way.
Do i need to write update routine or just the formula in update rule is enough ??
Thanks in advance