I have a situation where I need to export data from an expression rule to excel.
Previously I was using Export Data Store Entity to Excel smart service, but now as per the requirement I need to manipulate the data I get from database in an expression rule and then export it.
Kindly let me know your comments.
Sai Kiran Pannala.
Discussion posts and replies are publicly visible
Export CDT to Excel from the Excel Tools plugin, though deprecated, still works with current Appian versions, as of the last time I checked.
To confirm on versions we are still using Export CDT to Excel up to Appian 20.3. Waiting for an OOTB replacement! :)
Thanks for the response.
Actually I am querying the data from database table and then performing some operations in an Expression Rule. So my complete data/output comes from a Expression Rule but not from CDT.So could you please let me know if there is any way to generate an Excel from Expression Rule instead of CDT or DSE.
Is it possible in your scenario for you to store the result of your data manipulation in a temporary table and than export it instead the original table?
You just need to store the result of your data manipulation back into a CDT. If the manipulated data is too far removed from the original data to go back into a temporary copy of the same CDT type, then my fallback suggestion has always been to make a dummy CDT in your system that just has 10 or 20 text fields; then you can typecast your result to that and pass it into the Export CDT node.
But now that we can have PVs of type "map", it *may* be sufficient to just store the expression rule output as a "map" type variable and pass that into the node - I haven't tried this so it might not work, but it also might work fine. EDIT: just tried this and it seems to not work due to type mismatching. Bummer.
© 2021 Appian. All rights reserved.