Xpath in BPM correlation. Have to pass only few characters of a field in co

[Former Member]

Hi All,

Header file:

MDk-111;1728;175;02.09.11;781961.09;0.00;0.00;781961.09;;;;;;;;;0

MDk-112;8574;175;02.09.11;4462;1112;104098800;104102150;;;;;;;;;2

MDk-113;1729;175;02.09.11;781962.09;0.00;0.00;781961.09;;;;;;;;;0

MDk-114;8575;175;02.09.11;781963.09;0.00;0.00;781961.09;;;;;;;;;0

Detail file:

MDk-112;8574;175;02.09.11;;DEBIT;;;;;-1112;;0;02.09.11;;;;20555;;;037;

MDk-112;8574;175;02.09.11;;CREDIT;;;;;104098800;;0;02.09.11;;;;;;;099;

- I have to merge header and detail records into one target structure..

- For the records which doesn't consists of detail records should pass only header record. ex: MDk-113

- To merge the both the files, im using BPM with correlation.

The correlation which i need to use in BPM is the first record in both the files "MDk-XXX" where XXX is the number which may or may not match in both the files.. So i need to pass only first four characters of the first filed in the correlation ie. "MDK-".

After file content conversion, the input xml payload will be as below

<Code>MDK-112</bankCode>

How can I pass only first four characters of this field ("MDK-") in Xpath in the correlation tab?

Kindly suggest.

Thanks

Deepthi

[Former Member · Accepted solution]

Hi Deepthi,

You can send the substring of the Code value. This is explained in the following WIKI, have a look at this.

http://wiki.sdn.sap.com/wiki/display/XI/XpathConditioninReceiverDetermination

regards

Ramesh