Simple graphical mapping question

[Former Member]

Hi,

I have an issue in a graphical mapping I am trying to get working.

The issue is as follows:

I have a source structure defined :

<b><record>

<crmref>123456789</crmref>

<action>action1</action>

<action>action2</action>

</record></b>

The target should be like this:

<b><StatusUpdate>

<DocumentStatusUpdate>

<CRMReference>123456789</CRMReference>

<ExternalRef>action1</ExternalRef>

</DocumentStatusUpdate>

<DocumentStatusUpdate>

<CRMReference>123456789</CRMReference>

<ExternalRef>action2</ExternalRef>

</DocumentStatusUpdate>

</StatusUpdate></b>

However, what is happening is that the field for <CRMReference> is only getting filled on the first action and not on any subsequent ones like this:

<b><StatusUpdate>

<DocumentStatusUpdate>

<CRMReference>123456789</CRMReference>

<ExternalRef>action1</ExternalRef>

</DocumentStatusUpdate>

<DocumentStatusUpdate>

<CRMReference></CRMReference>

<ExternalRef>action2</ExternalRef>

</DocumentStatusUpdate>

</StatusUpdate></b>

I am just doing a straight source to target mapping for CRM Reference and I would have expected it to copy down onto all the contexts for the actions.

Am I doing something wrong ?

Kind regards

Colin.

[Former Member · Accepted solution]

Colin,

In the mapping of CRMRefernce, include the function 'CopyValue' (under 'Constants').

Kind regards,

Koen

[Former Member]

Hi Colin,

You can use the function useOneAsMany to repeat the value for field CRMReference.

It will require 3 arguments: first will be field CRMReference, second and third will be field action

and then use SplitByValue to change contexts on each value.

For the field action too , you need to use the splitbyvalue.

And map the DocumentStatusUpdate from the target to action field of source with same context as record.

Hope this will help.

Thanks.