Update not working when adding data to temp table and Js is not throwing any error but it is updating any tow. Any suggestions
var schemaName = vars.targetSchema.substring(vars.targetSchema.indexOf(":") + 1);
logInfo("Schem name = " +schemaName);
var formatString = function(str) {
blah blah blah..........................
return str;
}
var query = xtk.queryDef.create(
<queryDef schema={vars.targetSchema} operation="select">
<select>
<node expr="@Label"/>
<node expr="@FullName"/>
<node expr="@lineNum"/>
</select>
</queryDef>);
var resultSet = query.ExecuteQuery();
for each (var row in resultSet.enrich5)
{
//instance.vars.Label=formatString(row.@Label);
//logInfo(formatString(resultSet.enrich5.@Label));
xtk.session.Write(<query _operation="update" _key="@lineNum" Label= {formatString(row.@Label)} xtkschema="temp:enrich5"/>);
}