BizTalk Server Tutorial

BizTalk Server Concepts and Common Errors

Condition based String Concatenation

Today I came across a typical mapping Scenario which would be worth having a look.

The input message has a repeating record (“RepeatingRecord” in the below image), which has a Qualifier (“Qual” in the below image),   and a string node (“String” in the below image). Schema looks something like below.

Here the Main” record can occur Multiple times & RepeatingRecord” can occur Multiple times.

Sample input message will be like below.

Requirement now is whenever the “Qual” equals “10” throughout the whole input message, the corresponding String node values have to be concatenated.

From the resultant concatenated string, the first 3 characters should be mapped to a field in Target Message and the next 3 characters to another field. Target Schema looks something like below.

Target message should be something like below.

Here are the steps to achieve the mapping.

  1. Have a Logical Equal Functoid and Set one value to “Qual” node and another value to “10”.
  2. Have a Value Mapping Functoid and set one value to Logical Equal Functoid of step1 and another value to String node.        
  3. Connect the output of Value Mapping to the Cumulative Concatenate Functoid.
  4. The output of Step3 gives the Concatenated String for the whole input message where “Qual” is 10.
  5. Use String Extract Functoid to get the First 3 & next 3 characters and Map to the Target schema.                                                        

Though this is not a complex logic, it gives you some idea on using Conditional Cumulative Functoids.

January 19, 2012 - Posted by | Maps | , ,

1 Comment »

  1. what is the diff berween cumulative concatenate and string concateneat functoids

    Comment by Anonymous | September 3, 2013 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: