Data Conversion for Flatfiles in Sender-Adapter or Mapping

[Former Member]

Hi folks,

I get a flatfile - let's say - with three fields with names f1, f2 and f3, with the corresponding values. The adapter creates the following xml

<node1>

<f1>v1</f1>

<f2>v2</f2>

<f3>v3</f3>

</node1>

Has anybody an idea how to convert these structure into

<nodeA>

<name>f1</name>

<value>v1</value>

</nodeA>

<nodeA>

<name>f2</name>

<value>v2</value>

</nodeA>

<nodeA>

<name>f3</name>

<value>v3</value>

</nodeA>

without using Java? And if it is not possible how would a Java mapping look like? Or is it possible to create another structure with the file-adapter?

[bhavesh_kantilal · Accepted solution]

Hi,

Either use a Java Mapping or use an Adapter Module to do the content conversion and also create the fields with the field names so that they can be mapped in the target during message mapping.

Would suggest using Java Mapping though!

Regards,

Bhavesh

[Former Member]

You can make it with a graphical mapping, sending the normal XML to the integration server:

<node1>

<f1>v1</f1>

<f2>v2</f2>

<f3>v3</f3>

</node1>

and then changing the structure with a graphical mapping to:

<nodeA>

<name>f1</name>

<value>v1</value>

</nodeA>

<nodeA>

<name>f2</name>

<value>v2</value>

</nodeA>

<nodeA>

<name>f3</name>

<value>v3</value>

</nodeA>

Regards,

Sandro