Skip to main content
andreiionuti0001
andreiionuti0001
September 28, 2021
Question

Export big data to xls, xlsx or csv

  • September 28, 2021
  • 3 replies
  • 1 view

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!

3 replies

acaciob0002
acaciob0002
September 28, 2021

Hi [mention:283d5a97175942ef85df29739fda84fb:e9ed411860ed4f2ba0265705b8793d05]

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

andreiionuti0001
andreiionuti0001Author
October 5, 2021

Thank you for your reply, I will try to see if it works like this.

stewart.burchell
stewart.burchell
October 5, 2021

I always ask at this point *why* you want to export the data? It's much better left where it is. As soon as you export it, it's out of date.  If you need to use it for reporting (a common use case) you can point your tools at the data in situ rather than move the data to the tools.

Terms & ConditionsAccessibility statement