Issue in Excel Export

Hello Experts,   Here I am trying to export the list of objects in an excel. Assume that I have 2 records from db and one I have associated value as well where I am trying to export the associated data in the additional columns.   When the user clicks on export to excel I am not getting the records or object which is not associated with the main table.    In the above table row number 2 is not getting exported in an excel. Note that when I am retrieving in MF I am getting the list of all records but not only on the excel.   Any Idea?  
1 answers

You can change that behaviour in the Tab ‘Associations, constraints and sorting’ of the sheet in the export template. Change the Join type to ‘Left’.