Writing work table data in a Temp Table

Question

Hi - I have created a Temp table via JS in my workflow and want to insert data from the working table in that temp table, is it possible? If yes can you help me with JS for it? Regards,Tushar Varshney

DavidKangni · Accepted Answer

Hi, You may fetch temp schema like this:var schemaName = vars.targetSchema.substr(vars.targetSchema.indexOf(":") + 1);logInfo(schemaName);var query = xtk.queryDef.create();If you are sure in this above, you may try this for writing:var some_variable = ;xtk.session.Write(some_variable);Thanks,David

Manoj_Kumar · Answer

Hello @varshtus ,

I am assuming you have created a temp table with the JS and it is not created by any activity.

To read the data from the previous activity and store it in the temp table you can use this javascript code.

//reading the data rom the previous activity
var query = xtk.queryDef.create(<queryDef schema={vars.targetSchema} operation="select"><select><node expr="@id"/><node expr="@COLUMN1"/></select></queryDef>);
var resultSet = query.ExecuteQuery();


// Writing the data into the temp table

for each (var row in resultSet) {
     var COLUMN1= row.@COLUMN1;   
     var pId= row.@id;         
     sqlExec("INSERTO INTO TEMP_TABLE_NAME values("+COLUMN1+","+pID+"));
}

Let me know if that works.

Thanks

Sign up

Login with SSO

Login to the community

Login with SSO