Skip to Content
0
Former Member
Feb 11, 2011 at 04:58 AM

Mapping logic required--Counter

13 Views

Hi Experts,

How to increment the counter value by 5 every time, I tried using counter arithmetic function it is now working for my requirement.

My Source structure

<Elemica_Order> 
    <HItem>1..to unbouded
          <LItem>
               <Item>1..to unbounded

Target
          <Order>1..to unbounded
               <OItem>1 to unbouded
                    <id>

Order mapped with HItem and OItem mapped with lItem.suppose my source having 2 hitem records then target side I will have 2 orders.

my Hitem record having 3 LItems then my first order will have 3 order Items , in this case my I want to increment the ID value by each time by20, initial value is going to be 10.

Second Hitem having only one Litem then I want to increment value by 20.

I tried using counter arithmentic function, it is working for only one Hitem, second Hitem it is not reseting value to 20.

I think UDF required for this, help me

Regards,

Jam