Forum Discussion

daniel_stolsbot's avatar
daniel_stolsbot
New Contributor
6 years ago
Solved

Mapping flat incoming documents to object output

Hi, I have a csv file containing rows with customer orders which I want to map to an XML invoice object which generates an invoice containing all the customer orders. The incoming data looks like...
  • christwr's avatar
    christwr
    6 years ago

    Welcome to the community Daniel!

    Try a GroupByFields on CustomerId to create a document for each (InvoiceOrder), and then another generic GroupByN=0 to clump everything together into one document (Invoices) before converting to XML. Can also probably just convert as-is to XML, then use an XSLT to re-arrange/format as desired.

christwr's avatar
christwr
Contributor III
6 years ago

Welcome to the community Daniel!

Try a GroupByFields on CustomerId to create a document for each (InvoiceOrder), and then another generic GroupByN=0 to clump everything together into one document (Invoices) before converting to XML. Can also probably just convert as-is to XML, then use an XSLT to re-arrange/format as desired.

  • daniel_stolsbot's avatar
    daniel_stolsbot
    New Contributor
    6 years ago

    Thank you for the swift reply! Got the correct formatting by using GroupByFileds followed by GroupByN as you described.