UDF: mapping query-------Urgent

[Former Member]

Hi... I have the Following requirement:

Source structure:

Field1 1..1

Field2 1..1

Field3 1..n

Field4 1..1

Field5 1..1

Field4 and Field5 are subelements of Field3.

I have to concatenate them and pass into a single field.

I have to cocatenate in this way.

Field1

-

---

Field2

-

---

Field4+Field5

-

---

Field4+Field5

-

---

and so on...

i am using a UDF to concatenate and send. But how i get in this format with a new line filled with 10 hiphens.

Please help me resolve this.

[Former Member · Accepted solution]

i am using a UDF to concatenate and send. But how i get in this format with a new line filled with 10 hiphens.

I could not understand what you output should be. If you are trying to figure out how you can get multiple field4 + field 5 entries on the target side for every occurence of u r field3 which is 1..n.

Then you can look at using the concat function and setting the "context"(right click on the field to change the context) of the input fields (field4,field5) as the source structure and not field3.

Cheer's

[Former Member]

hi... thanks for your replies...

i wrote a UDF with "\n" and that solved the problem.

[Former Member]

Hi,

Try using the concatanate function from the graphical mapping.

Regards,

Kumar.