I am implementing a feature in OutSystems where aggregate data is downloaded as an Excel file. While the data exports successfully, the column names in the Excel file are not in the desired order.
For example:
The current column order is: Team Name, Sub Task Category, Member Name and Task Category etc.
I want the column order to be: Team Name, Member Name, Task Category and Task sub Task Category etc.
How can I rearrange the column order in the exported Excel file?
Your guidance or an OML file for a similar use case would be helpful!
Hi @Pavani Vislavath ,
Create a structure which contain all attribute in your order and mapped in DownloadAsExcel.
I attached a sample OMl review It .It show first username and second one Name.
Regards ,
Rajat
Hi @Pavani Vislavath,
1. Create a structure based on your order i.e., Team Name, Member Name, Task Category and Task sub Task Category etc.
2. Create a local variable ( datatype as newly created structure list).
3. Append all data into the local variable.
4. Export this local variable into excel, you will get the expected output.
Thanks,
Lavanya Kamalaguru.
Create a new structure with the order you want in the excel sheet, and map the aggregate fields to the new structure fields. that should work for you.
Jithu