on 04-14-2008 12:43 AM
Hello everybody,
I have the following issue:
I have the next flat file:
0001;159;2008-04-03;Customer_2008-04-03.xml
0001;953;0;1;0
0002;2907;0;1;0
And I have to convert it to the next XML structure:
<DocumentsBatch id="0001" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<BatchInfo>
<SumDocumenten>159</SumDocumenten>
<date>2008-04-03</date>
<name>Customer_2008-04-03.xml></name>
</BatchInfo>
<Document id="0001">
<Customer>953</Customer>
<Portnumber>0</Portnumber>
<denied>1</denied>
<Port>0</Port>
</Document>
<Document id="0002">
<Customer>2907</Customer>
<Portnumber>0</Portnumber>
<denied>1</denied>
<Port>0</Port>
</Document>
My question is: Is it possible to define an attribute (e.g. id="0001" in <Document id="0001">) in File Content Conversion? If so, how can I do that?
Your answers will be rewarded with points.
Kind regards,
Kamran
Hi Kamran,
its not possible to define attribute in File Content conversion.Instead u can create one more field "id" under the segments DocumentsBatch, Document etc.
Thanks
Ritu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes and also
You have nothing in this flat file as a key ?. that is you have nothing that identifies which is the Header and which is the Body line ?
Without that you might not be able to achieve this.
Perhaps see this blog
[Content Conversion ( The Key Field Problem )|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3228] [original link is broken] [original link is broken] [original link is broken];
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.