Loop Concatenating in Message Mapping

[Former Member]

Dear Experts,

We have to Concatenate all the entries of a table in a string field, we want to do with graphical mapping. An example is:

Source:

<ITEM>

<TEXT>A</TEXT>

</ITEM>

<ITEM>

<TEXT>B</TEXT>

</ITEM>

<ITEM>

<TEXT>C</TEXT>

</ITEM>

Target:

<XML>

<TEXT>A B C</TEXT>

</XML>

Somebody knows if it is possible with graphical mapping?

Any help will be appreciated.

Thans and regards,

MML.

[PriyankaAnagani · Accepted solution]

Hi,

You can achieve this with simple UDF...

textremovecontext-concatUDF---targetText

public void concatUDF(String[] var1, ResultList result, Container container) throws StreamTransformationException{

String res = "";

for(int i=0;i<var1.length;i++){

res = res" "var1<i>;

}

result.addValue(res);

}

Regards,

Priyanka

[Former Member · Accepted solution]

Thank you very much.

This has solved my problem.

[Former Member]

You will need to write an advanced UDF to do this

Using Java code, you could retrieve all the values of a queue and then concatenate them

rgds