Can we export output of Expression Rule to Excel?

Export CDT to Excel from the Excel Tools plugin, though deprecated, still works with current Appian versions, as of the last time I checked.

Hi Mike,

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.

Thanks.

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.

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.

So should we need to insert the manipulated Data again to dummy table and the use export CDT to excel?
and in this case how to truncate table for every trigger of process. Please suggest.

Hi Lavanya,

I would suggest to use procedure to truncate the table.

There is no need to insert the manipulated data back into DB. As Mike also mentioned, Export CDT to Excel only needs data in the form of a CDT, just store the data in a temporary CDT and pass it to smart service.