Skip to Content
0
Former Member
Feb 09, 2006 at 04:08 PM

How to populate multiple records into 1 using addtl keyfigs

13 Views

Hi Gurus,

Please take a look at this scenario.

I have 3 records coming from source system.

ex:

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

-dooDle