How to add insert data which is populated from enrinchment?

Forum|Forum|5 years ago
February 7, 2020
2 replies
4773 views

Hi, I have enrichment with all the data i want.

Now i am trying to insert into table through java script. I dont want to use update sql activity due to some table transformation. How do i derive the data which populated in enrichment in java script. For ex

sqlExec("insert into gow:SampleDB(std_id,name) select std_id, name from vars.targetSchema");

i want std_id and name from enrichment table.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by InderM

Hi,

you can use queryDef to fetch the data from targetSchema as shown below

var conditionVar="@age > 25";// example condition
var recordSet = xtk.queryDef.create(
<queryDef schema={vars.targetSchema} operation="select">
<select>
<node expr="@std_id"/>
<node expr="@name"/>
</select>
<where>
<condition expr={conditionVar} />
</where>
</queryDef>
);

var allRecords = recordSet.ExecuteQuery();
for each (var rec in allRecords)

{
var var1=rec.std_id;

var var2=rec.name;

//your INSERT statement;
}

hope this helps.

I

InderMAccepted solution

Level 2