Skip to Content
0
Former Member
Nov 02, 2005 at 07:58 AM

Mapping problem

15 Views

Hi,

I want to convert a txt-file into a xml-file.

The structure of the txt-file is:

Source_value_1a;source_value_2a;source_value_3a

Source_value_1b;source_value_2b;source_value_3b

Source_value_1c;source_value_2c;source_value_3c

In the message monitoring the xml-file is correct generated:

<schema>

<Recordset>

<source>

<source_value_1>Source_value_1a</source_value_1>

<source_value_2>source_value_2a</source_value_2>

<source_value_3>source_value_3a</source_value_3>

</source>

<source>

<source_value_1>Source_value_1b</source_value_1>

<source_value_2>source_value_2b</source_value_2>

<source_value_3>source_value_3b</source_value_3>

</source>

<source>

<source_value_1>Source_value_1c</source_value_1>

<source_value_2>source_value_2c</source_value_2>

<source_value_3>source_value_3c</source_value_3>

</source>

</Recordset>

</schema>

but there is something wrong with the mapping.

The mapping looks like this:

schema --> schema

Recordset --> Recordset

source --> source

source_value_1 -->source_value_1

source_value_2 -->source_value_2

source_value_3 -->source_value_3

So the output of the mapping looks like this:

<schema>

<Recordset>

<source>

<source_value_1>Source_value_1a</source_value_1>

<source_value_2>source_value_2a</source_value_2>

<source_value_3>source_value_3a</source_value_3>

</source>

</schema>

Can anybody help me please?

Thanks.

Regards

Stefan