Export big data to xls, xlsx or csv

Question

Hello, 
 
 I am using Appian 21.2 on cloud version (MariaDB) and I have 2 Views: 
 1) one view with 30 columns and ~300k rows which works pretty fast 2) second view with 85 columns and ~140k rows which takes around 8-9 seconds to load 
 I know that using the standard smart services you cannot have more than 50 columns and max 100k rows and whenever I use the smart service Export SQL To Excel it breaks "max_statement_time" exceeded. 
 Also querying a few rows from the second view won't be possible since it breaks. 
 
 Any idea for OOTB solutions? 
 
 Thank you!

Acacio Barrado · Answer

Hi Andrei Iordache 
 Your problem is quite a common use case, unfortunately there is no OOTB solution for this. The best way to achieve this would be to export the data into multiple excel files (e.g. in one excel file you have 50 columns, in the other you have 35). 
 Once you have these files, you can utilize this plugin https://community.appian.com/b/appmarket/posts/excel-template-merge . 
 It will allow you to merge the excel files (with a custom template if you require it) both vertically and horizontally. Hopefully this helps - let me know if you require help configuring the plugin. 
 Regards, 
 Acacio B