Hi ,
I am using SQL code activity to do insert into custom table . From the the below code i want the data from enrichment before sql code activity. Can some one give me sample query to fetch values from enrichment and insert into table.
INSERT INTO Customtable(column1, column2, column3, ...)
SELECT column1(From enrichment), column2, column3(From enrichment), ...
FROM enrichment.
Solved! Go to Solution.
Views
Replies
Total Likes
Hi,
If you are trying to view the data being inserted then you can either perform a preview, or you can execute the workflow to the point where the enrichment runs, then simply right click on the output transition from the enrichment. This will allow you to view the data and export it if desired.
When it comes to inserting the data, I would not recommend using the SQL Code activity but instead using the update data activity. The SQL activity doesn't actually execute SQL within the activity itself but calls upon templates (see documentation below):
Regards,
Craig
Hi,
If you are trying to view the data being inserted then you can either perform a preview, or you can execute the workflow to the point where the enrichment runs, then simply right click on the output transition from the enrichment. This will allow you to view the data and export it if desired.
When it comes to inserting the data, I would not recommend using the SQL Code activity but instead using the update data activity. The SQL activity doesn't actually execute SQL within the activity itself but calls upon templates (see documentation below):
Regards,
Craig
I want to invert the table which i am getting from enrichment. So is there any other way to do this with our SQL code activity?
ID FirstName LastName Email
1 Name1 Name12 Email1
2 Name2 Name22 Email2
3 Name3 Name32 Email3
i want to convert above table into
ID AttributeName AttributeValue
1 FirstName Name1
1 LastName Name12
1 Email Email1
2 FirstName Name2
2 LastName Name22
2 Email Email2
Views
Replies
Total Likes
Views
Likes
Replies