Export data to excel

Question

I have datas saved in Appian DB , I want to export all the datas into an excel and store in into a shared location and the datas need to be deleted after exporting to excel .And this process need to be performed on the starting of every month .

Any suggestions how to achieve this .

Any suggestions how  to achieve this .

harshitb6843 · Answer

Configure the start node to run at the scheduled date and time on every monthUse 'excel tools' plugin to convert database data into excel. Store that excel in the dedicated folderDelete the data from the table using 'Execute SQL' smart service or delete from DSE with all the identifiers.

Sign up

Login with SSO

Login to the community

Login with SSO