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