How to export all the record in excel sheet if some data is empty

0
Hi all , I am facing issue with excel export. for example I have a two entities Entity one-name,add,age  and Entity Two: height weight fields and both entities has association in between. In entity one and and two name, add, height are the mandatory fields. But if for any record non-mandatory fields are empty then it will not export that record. And I want to export that record also. How to do this. Can anyone guide me?   Thanks
asked
1 answers
0

Hi Priyanka,

 

You want to export the data to Excel as one Worksheet with 5 Columns (name, add, age, height, weight). In that case, I would create a non-persistent entity with those 5 Attributes, fill it using a microflow, and trigger the export from that microflow. 

https://docs.mendix.com/howto/integration/using-the-excel-exporter/#7-calling-the-excel-export-module-via-microflow

 

In your current way of working, you only make an export if that association exists.

 

Go Make It

answered