Skip to main content
H
harriesrillm0002
April 12, 2022
Question

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

  • April 12, 2022
  • 2 replies
  • 0 views

I want to export a multiple data using the expression rule, Can export to excel export that data? 
for example 0001, abcd, ads, sda
0002, abcd, ads, sda
0003, abcd, ads, sda
Total of 0003 

2 replies

gopalk2865
gopalk2865
April 12, 2022

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.

harshitb6843
harshitb6843
April 12, 2022

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. 

Terms & ConditionsAccessibility statement