Condition based String Concatenation

You can download the entire article as a PDF document.
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.

You can download the entire article as a PDF document.
Condition based String Concatenation
  • Anonymous

    what is the diff berween cumulative concatenate and string concateneat functoids

BizTalk360
BizTalk Server

Over 500+ customers across
30+ countries depend on BizTalk360

Learn More
Serverless360
Azure

Manage and monitor serverless
components effortlessly

Learn More
Atomicscope
Business Users

Monitor your Business Activity in iPaaS
or Hybrid integration solutions

Learn More

Back to Top