on 09-10-2008 8:14 PM
Hi all,
I have a scenario where i need to merge all the values in a field for all instances and put it in one string target field. Can any body please suggest how to do that?
Source:
S-----
|-- Sequence
|-- Value
For all values of sequence (1,2,3,4 ...) Merger Value into one sigle string
Thanks and best regards,
Kulwant
The solution shuld work if you are not checking the sequence.
Please let me know if we need to check the sequence
Rgds
Aditya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Use Advanced User define Function. Create a UDF with Cache as Context and write the following code. It should work. Use this function between your source field sequence and target desired field.
If it doesn't work change the Context path of your source sequence field to point it to its one more level up node.
String newSeq = "";
for(int i=0;i<a.length;i++)
{
newSeq = newSeq+a<i>;
}
result.addValue(newSeq);
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.