Skip to Content
0
Former Member
Nov 07, 2005 at 06:38 PM

Concatenating fieldvalues and fieldnames in mapping

22 Views

Hi everyone, I need some help from the experts in this forum about mapping in Integration Designer.

I have several parameters in a file (.TXT) that I need to extract then send to a web service. This web service needs to receive these parameters in a format mimicking XML. For example:

(TXT File) 002, Test, A704

these need to transform into

<Fieldname1>002</Fieldname1><Fieldname2>Test</Fieldname2><Fieldname3>A704</Fieldname3>

I can't use WSDL because the web service only receives a single string, not XML formatted. It needs to be a single string formatted by me.

I can concatenate the field values in mapping to create the string:

002TestA704

but I'm having difficulties putting the fieldnames in there. Is there a way to put them there in mapping?

Thanks in advance for your help.