|
| Hi
i receive a flat file and i should generate an xml.
I receive a flat file which is having following structure.
File
Document1
Header
Vendor1
Accounting1
Accounting2
vendor2
Accounting3
Accounting4
Document1
Document2
Header
Vendor3
Accounting5
Accounting6
vendor4
Accounting7
Accounting8
Document2
File
each record is having tagidentifier 1 for document 2 for header 3 for vendor
4 for accounting.
one file can contain any no of documents.in one document it should conatain
one one header ,one vendor record followed by 2 accounting records ,next
vendor record followed by two accounting records and so on.
i created a schema in biztalk 2004 which i validated against an test file it
is generating xml correctly.in the destination also i created a similar
structure.
after mapping my source to destination, in the output --- inside the
document header followed by all vendor records in a document and then all
accounting records.
in my output xml iam getting
file
document
header
vendor1
vendor2
vendor3
Accounting1
Accounting2
Accounting3
document
file
but iam trying to get
File
Document
Header
vendor1
Accounting1
Accounting2
vendor2
Accounting3
Accounting4
Document
File
i have to generate the xml in the similar structure how i receive the data
in flatfile.
can some one help me asap.This is very urgent for me ....
Thanks in advance...
--
gopal
|
|