Convert Data From Global Temporary Table to Excel

Question

I am trying to get a temporary table data by executing a stored procedure. This stored procedure is responsible to create a temporary table, insert some hard cored values (id and name as fields) and then dropping the temporary table. Before dropping Inam using select all statement so to get my data before dropping the table. But somehow I got the data which is similar to this, 
 &#123; 
 &#123; id = 1, name = Abc &#125;, 
 &#123; id = 1, name = Pqr &#125;, 
 &#123; id = 1, name = Uvw &#125;, 
 &#123; id = 1, name = Xyz &#125;, 
 &#123; id = 1, name = Ijk &#125; 
 &#125; 
 It looks like 2D list of map. can anyone help me in binding the data to excel using Export DataStoreEntity to Excel and Execute Stored Procedure smart services.

Mathieu Drouin · Accepted Answer

Not possible to map a DSE to a temp table AFAIK. 
 I would simply add a column for the username in the table and use that as a filter for the export. Delete the data linked to the user after the export. 
 Of course this approach would depend on the amount of users in the system as well as the quantity of data we are talking about but it is pretty much the only approach I can think of that could work.

Mathieu Drouin · Answer

Instead of dropping and recreating the table why not just create it once and map the CDT and just truncate and re-insert the data?

Convert Data From Global Temporary Table to Excel

Top Replies