Mapping Logic

[sahana_ps]

Hi all,

I have a requirement ,

my sender structure looks like

Header       1...UNBOUND

Item1          1...UNBOUND

Item2          1...UNBOUND

target structure is like

Header         1...UNBOUND

Item1            1...UNBOUND

     Field1       1...1

Item2             1...UNBOUND

here  Target 'field 1' should be mapped with 'item1' from sender .Initialy its mapped with constant 001.later it should be incremented for every occurance of Item1 in source

Thanks,

Sahana

[amankumarmangla · Accepted solution]

Hello Sahana,

It can be easily be achieved as shown below. Read about 'Index' and 'FormatNumber' functions. In Index function you can choose if you want to reset the counter to initial value with every change of context.

Kindly let us know if this solves your purpose.

Regards,

Aman

[Former Member]

Hi Sahana,

You can achieve this with graphical variable concept also.

Please check this for graphical variable info:

Regards

Raj

[markangelo_dihiansan]

Hi Sahana,

You could use the index function (found in statistic functions), from there you could set the increment and the option whether to reset counting per context change.

Hope this helps,

Mark

[Muniyappan]

Hi,

is item1 from sender mapped to item1 receiver?

if yes for every item1 occurrence to increment field1 you can use counter function.

give intial value 001 and increment as per your wish.

Regards,

Muni.