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.

mathieud0001 · 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.

mikes0011 · Answer

You'll need to use the Export DSE to Excel node prior to dropping the temporary table.  Assuming the temporary table looks like what you're wanting, that should be sufficient.

Sign up

Login with SSO

Login to the community

Login with SSO