Nested Regions creating multiple rows instead of single row

Aspose.Words Product Family
1

I am using this code

DataSet dataSet = new DataSet();

// Approver's main information
DataTable tblApprovers = new DataTable("ApproverDetails");
tblApprovers.Columns.Add("ApproverDescription", typeof(string));
tblApprovers.Columns.Add("ApproverName", typeof(string));
tblApprovers.Columns.Add("ApprovalStatus", typeof(string));
tblApprovers.Columns.Add("ApprovalDate", typeof(string));
tblApprovers.Columns.Add("EmployeeCode", typeof(string));
tblApprovers.Rows.Add("Desc1", "Approver1", "Approved", "05 Jul, 2024 15:13","Admin");


// Approver's attributes
DataTable tblAttributes = new DataTable("ApproverAttr");
tblAttributes.Columns.Add("EmployeeCode", typeof(string));
tblAttributes.Columns.Add("Key", typeof(string));
tblAttributes.Columns.Add("Value", typeof(string));
tblAttributes.Rows.Add("Admin", "Location", "Mumbra");
tblAttributes.Rows.Add("Admin", "Designation", "Business Head");
dataSet.Tables.Add(tblApprovers);
dataSet.Tables.Add(tblAttributes);
dataSet.Relations.Add("Approvers_Attributes",
                      tblApprovers.Columns["EmployeeCode"],
                      tblAttributes.Columns["EmployeeCode"]);

    Document doc = new Document("path_to_template.docx");

    // Handle the mail merge with nested regions
    doc.MailMerge.ExecuteWithRegions(dataSet);

    // Save the output document
    doc.Save("output.docx");

TestDoc.docx (32.8 KB)

But as you can see 2 rows are generating, how to resolve this.

2

@SachinSingh The output is expected with your template. To get the expected output you should use a nested table in your template. For example see the following modified template and the produced output:
in.docx (29.8 KB)
out.docx (26.2 KB)

Also I have modified the code a little:

Document doc = new Document(@"C:\Temp\in.docx");

// Handle the mail merge with nested regions
doc.MailMerge.CleanupOptions = MailMergeCleanupOptions.RemoveEmptyParagraphs;
doc.MailMerge.ExecuteWithRegions(dataSet);

// Save the output document
doc.Save(@"C:\Temp\out.docx");