Hi Guys. Need your help here!!
I am having two columns which has to be multiplied and the result should be stored in a new column.
I used
“Connect”
“Executequery”
When I use UPDATE Sheet1$ SET Totalcost=Units*CostofProduction I am getting error
Compiler error encountered while executing expression UPDATE Sheet1$ SET Totalcost=Units*CostofProduction. end of expression expected.
sample.xaml (15.2 KB)
I am here attaching the workflow that I did till now, expecting your valuable suggestions. Thanx in advance guys…
my DB
units costofproduction totalcost
30 1567 NULL
15 10787 NULL
12 10982 NULL