Dynamics Community Forum Thread Details

Trying to export 2 datasets in 1 line

I am trying to export data to a CSV file. In my XMLPort there are two datasets that I am exporting, but I need them to come out on one line. So it should look like this:

xmlport 14135103 "ExportSales"
{
    Caption = 'Export Sales';
    Direction = Export;
    TextEncoding = UTF8;
    Format = VariableText;
    FieldDelimiter = '"';
    FieldSeparator = '';

    schema
    {
        textelement(root)
        {
            tableelement(SalesInvoiceHeader; "Sales Invoice Header")
            {
                XmlName = 'SalesInvoiceHeader';
                fieldattribute(Code; SalesInvoiceHeader."No.") { }
                fieldattribute(PostingDescription; SalesInvoiceHeader."Posting Description") { }
                fieldattribute(PostingDate; SalesInvoiceHeader."Posting Date") { }
                fieldattribute(DocumentDate; SalesInvoiceHeader."Document Date") { }
            }
            tableelement(SalesInvoiceLine; "Sales Invoice Line")
            {
                XmlName = 'SaleInvoiceLine';
                fieldattribute(Type; SalesInvoiceLine."Type") { }
                fieldattribute(Code; SalesInvoiceLine."No.") { }
                fieldattribute(Description; SalesInvoiceLine."Description") { }
                fieldattribute(Quantity; SalesInvoiceLine."Quantity") { }
                fieldattribute(UnitPrice; SalesInvoiceLine."Unit Price") { }
                fieldattribute(Amount; SalesInvoiceLine."Amount") { }
            }
        }

    }


}

Above is the code I have. Does anyone know how to achieve this?

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS