hii guys,i just struck in the middle of the process, my query is initially i scraped data from the eCommerce website and stored it in a datatable which contains 3 columns and used for each loop,in body section i used assign activity to store each row value to three variables say product,url,price. i tried to add each row value to the database it worked but only the variables are added to it not the values
2 Likes
Could you please show me how you assigned values ?
i assigned each row value to the variables product,url,price.and i placed those three variables in the values place i execute non query.
1 Like
Remove that single quotes for those variables and then try once.
@lakshman no its not working saying invalid column names
not working
Could you please share your workflow with me. Need to check once.
@lakshman sure folder.zip (21.8 KB) have a look
1 Like
@lakshman thanks for your time buddy,i got the output
1 Like
In your database, What is the data type for product, price and url ? Is it string or not ?
And also product and price variables are Generic variables and change it to string and then try.
@lakshman hii i get the data from my datatable to database but it retrieved some rows and for some rows only variables names pasted
1 Like
Please show me your Execute Query once.
Please follow below steps.
-
put that Connect activity outside of the loop and make it as first step.
-
Then read data from Excel file and use For Each Row activity to iterate that data.
ForEach row in DataTable - use Execute Non Query and pass insert query like this:
“INSERT into product(product,url,price) Values(’ “+row(“product”).Tostring+” ', ’ “+row(“url”).Tostring+” ', ’ “+row(“price”).Tostring+” ')”
ashokkarale
Akash_Javalekar1
KezayAlperen
Yoichi
naveen.s