<Moderator: split from this topic>
hi.
Regarding the last question,
i merged the chunk xml with transformer:
in the deviration i put somthing like :
'<street>' : seq_addr_in.STREET :
'</street><city>' : seq_addr_in.CITY :
'</city><state>' : seq_addr_in.STATE :
'</state><zip_code>' : seq_addr_in.ZIP_CODE : '</zip_code>'
in the final document i get all the tags in one row
how can i split the tags to diffrent rows ?
Complex XML document
Moderators: chulett, rschirm, roy
Hi Craig.
Im building a complex XML document as shown in 'Xml Best Practices'
document, if you familiar with it.
and this is the part of the addresses (3.1.3.1.2)
Do you have a better way to to that example ?
Basically i need to create XML document with one file_header record in the begining and alot of data records so i used the above examlpe.
this is what i need
<?xml version="1.0"?>
<File_Header>
<RecordType>x</RecordType>
<ActionCode>abcs</ActionCode>
<NumberOfRecords>1</NumberOfRecords>
<ProviderCode>1</ProviderCode>
<FileReference>123</FileReference>
<DateFile>201010130945</DateFile>
<Data>
<DataType>D</DataType>
<IdentificationNumber>321423166</IdentificationNumber>
<CustomerNumber>25252</CustomerNumber>
<PayingCustomerNumber>5555</PayingCustomerNumber>
<RequestType>1</RequestType>
<IpostNumber>RT7654</IpostNumber>
<ErrorCode>5</ErrorCode>
<ErrorDescription>aaaaa</ErrorDescription>
</Data>
<Data>
<DataType>D</DataType>
<IdentificationNumber>35765466</IdentificationNumber>
<CustomerNumber>25252</CustomerNumber>
<PayingCustomerNumber>5555</PayingCustomerNumber>
<RequestType>1</RequestType>
<IpostNumber>RT7654</IpostNumber>
<ErrorCode>5</ErrorCode>
<ErrorDescription>aaaaa</ErrorDescription>
</Data>
</File_Header>
Im building a complex XML document as shown in 'Xml Best Practices'
document, if you familiar with it.
and this is the part of the addresses (3.1.3.1.2)
Do you have a better way to to that example ?
Basically i need to create XML document with one file_header record in the begining and alot of data records so i used the above examlpe.
this is what i need
<?xml version="1.0"?>
<File_Header>
<RecordType>x</RecordType>
<ActionCode>abcs</ActionCode>
<NumberOfRecords>1</NumberOfRecords>
<ProviderCode>1</ProviderCode>
<FileReference>123</FileReference>
<DateFile>201010130945</DateFile>
<Data>
<DataType>D</DataType>
<IdentificationNumber>321423166</IdentificationNumber>
<CustomerNumber>25252</CustomerNumber>
<PayingCustomerNumber>5555</PayingCustomerNumber>
<RequestType>1</RequestType>
<IpostNumber>RT7654</IpostNumber>
<ErrorCode>5</ErrorCode>
<ErrorDescription>aaaaa</ErrorDescription>
</Data>
<Data>
<DataType>D</DataType>
<IdentificationNumber>35765466</IdentificationNumber>
<CustomerNumber>25252</CustomerNumber>
<PayingCustomerNumber>5555</PayingCustomerNumber>
<RequestType>1</RequestType>
<IpostNumber>RT7654</IpostNumber>
<ErrorCode>5</ErrorCode>
<ErrorDescription>aaaaa</ErrorDescription>
</Data>
</File_Header>
I don't see the correlation between the first question and this one, or with the other post which is why I split this one off. And I'm not sure how 'complex' what you are trying to do is. However, it seems like building those <Data> elements as chunks and then merging them together with the header XML should work fine.
What exactly are you doing and what issues are you having? Getting your output all in "one row" isn't really a problem as long as the XML is valid. Can you try again to clarify your question, please?
What exactly are you doing and what issues are you having? Getting your output all in "one row" isn't really a problem as long as the XML is valid. Can you try again to clarify your question, please?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers