AnsweredAssumed Answered

Sequence number while splitting the xml element

Question asked by madhushree.krishnamurthy@logicinfo.com on Sep 6, 2018
Latest reply on Sep 6, 2018 by leif_jacobsen

I have a xml destination profile similar to one as shown below.

<RE>

<bdate></bdate>

<Tran_NO></Tran_NO>

<LI1>

<seq_no></seq_no>

<cost></cost>

<gm></gm>

</LI1>

</RE>

Here I am splitting the xml with respect to the <RE>. RE and LI1 are unbounded elements. I have used "line item increment" function to assign values to seq_no. It increments seq_no continuously even for the next occurrence of RE. I need to reset the value to 1 once the 1st occurrence of RE has been closed. I tried giving reset value with cache by mapping and cache by document and they didn't work. How to reset seq_no?

Outcomes