Re: Flat File repeating

I don't care if I get one output file or two. The data is comming in as 1 XML
Document. The problem is that the way it is grouping on the output makes it
so there is no way to determine which invoices go with which check.

"Leonid Ganeline" wrote:

Please, give more detail.

Is it:

This is what I want:
Company,comp1
Check No,123
Invoice No,Invoice Amt
123,1234

Company,comp2
Check No,456
Invoice No,Invoice Amt
456,5678
789,9876


- the one output message or two?
--

Regards,

Leonid Ganeline
BizTalk Developer,
Microsoft Certified Technology Specialist: BizTalk Server 2006
http://geekswithblogs.net/leonidganeline/

"wendld" <GenieLifts@xxxxxxxxxxxxxx> wrote in message
news:82890BD9-BF5E-4731-9B5E-18B6DA8BCD3D@xxxxxxxxxxxxxxxx
I have a message I am trying to format into a csv file. I have everything
working, but the format is off when I get multiple records. Please see my
examples below and let me know if there is a way to correct this.
Basically
even though the check element repeates in the XML the structure of the
file
does not. The labels are added using string functoids and are not part of
the
XML.

XML looks like:
<RemitInfo>
<Check>
<company>comp1</company>
<checknum>123</checknum>
<Invoice>
<InvoiceNum>123</InvoiceNum>
<InvoiceAmount>1234</InvoiceAmount>
</Invoice>
</Check>
<Check>
<company>comp2</company>
<checknum>456</checknum>
<Invoice>
<InvoiceNum>456</InvoiceNum>
<InvoiceAmount>5678</InvoiceAmount>
</Invoice>
<Invoice>
<InvoiceNum>789</InvoiceNum>
<InvoiceAmount>9876</InvoiceAmount>
</Invoice>
</Check>
</RemitInfo>

This is what I wind up with
Company,comp1
Company,comp2
Check No,123
Check No,456
Invoice No,Invoice Amt
123,1234
456,5678
789,9876

This is what I want:
Company,comp1
Check No,123
Invoice No,Invoice Amt
123,1234

Company,comp2
Check No,456
Invoice No,Invoice Amt
456,5678
789,9876




.

Relevant Pages

  • Re: Flat File repeating
    ... The problem will be in the map, something to do with how looping is set up. ... Invoice No,Invoice Amt ... XML looks like: ...
    (microsoft.public.biztalk.general)
  • Re: Flat File repeating
    ... Invoice No,Invoice Amt ... Microsoft Certified Technology Specialist: BizTalk Server 2006 ... XML looks like: ...
    (microsoft.public.biztalk.general)
  • Re: Query
    ... > Invoice no. Amt ... > Invoice no. Pamt Pdate ... I already tried to use Query or Pivot ...
    (microsoft.public.excel)
  • Query
    ... Invoice no. Pamt Pdate ... Invoice no. Amt Pamt Pdate ... How to make it under Excel 97 ?? ...
    (microsoft.public.excel)
  • Re: LaTeX packages for finance-related documents?
    ... Peter Flynn writes: ... I neglected to do a search for "invoice" on ... Please don't :-) There are international standards for these in XML, ...
    (comp.text.tex)
Loading