Mapping request

[Former Member]

Hi Experts,

In one repeated source segment according to the field values I have to do the count and assign to the target field.

if ( (NAME != "SR") or (NAME == "NV")) // for this case count the segment

{

Target value = count(Repeated Segment);

}

else

{

if ( NAME =="SR") // keep constant value

{

Target value = 1;

}

How to do this mapping in XI?

Regards

Sara

[dharamveer_gaur2 · Accepted solution]

Hi

You can use standard Count function with If condition(Use Constant).

[SudhirT]

hi Sara,

Use like this

SourceField------RemoveContext------Sort------SplitbyValue(Change)----->Count---->TargetField

Thanks!

[former_member200962]

Hi,

If it is the count that you want (0,1,2,3...) then in addition to the if statement you can use the counter function available in MM.

Regards,

Abhishek.