How to export in excel the manipulate data in expression rule?

Hi, earlier there was a smart service from Excel tools called "export cdt to excel" . You could have used that but is not in use . As of now what you can try is , creat a temporary table and after manipulating data in expression rule  ,insert these data into temporary table and with the help of export to dse smart service, you can export.

I would also suggest implementing Gopal's suggestion. Just one more point from my side. try creating a stored procedure if the data volume can be huge in the future. That SP will manipulate the data, and store it in the table. After that, you can run the smart service to export and then delete the data from that table. 

I would also suggest implementing Gopal's suggestion. Just one more point from my side. try creating a stored procedure if the data volume can be huge in the future. That SP will manipulate the data, and store it in the table. After that, you can run the smart service to export and then delete the data from that table.