Excel Exporter

0
Hello Team,   I am using Excel Exporter and in template configuration using reference data. Entity A and B is having Many to many association. After downloading excel, for example data with id 1 is having two values but in excel it is showing two rows with id 1 and two different values. Is there any way to merge it with one row?
asked
1 answers
0

Hi  Sidheshwari,

 

To merge rows with the same ID in your Excel export, you can concatenate the associated values into a single cell. 

  1. Add a string attribute in main entity: Add a new string attribute in entity A to store the combined values from entity B.

  2. Use a Microflow to Populate the Attribute:

    • Retrieve the associated entity B objects for each entity A object.
    • Loop through the retrieved records and concatenate their values into a single string.
    • Set the concatenated string to the attribute in entity A.

  3. Update the Excel Template: In the excel exporter template, use the  attribute instead of directly referencing the association.

Comment below if you have any doubts.

 

Thanks

answered