Hi @Salman Shaik
Both solutions make the same correctly.
The only different between these two solutions is the time that its takes to complete.
As I said in my previos post, is not the same to execute one update with all the fields than execute 70 updates with only one field. Of course, in both solutions you replace the *, but the second one takes several minutes to complete.
To ilustrate this, I make bigger my example Excel with 80 fields and 70.000 lines.
I duplicate my example to make as you suggest, the update inside the loop, and I take the time with two variables and the function Now()
Running the first one, one update outside the loop its take 30 seconds to be completed:
Then I run your suggestion, the update inside, and it takes me more than 10 minutes.
Why is this happening? Because if you go field by field you waste a lot of time opening and closing the command execution.Of course, my solution is not perfect, if you have too many fields in an update you may get the opposite effect and it may take longer.
Now is more clear?
Bye 🙂
------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------
Both solutions make the same correctly.
The only different between these two solutions is the time that its takes to complete.
As I said in my previos post, is not the same to execute one update with all the fields than execute 70 updates with only one field. Of course, in both solutions you replace the *, but the second one takes several minutes to complete.
To ilustrate this, I make bigger my example Excel with 80 fields and 70.000 lines.
I duplicate my example to make as you suggest, the update inside the loop, and I take the time with two variables and the function Now()
Running the first one, one update outside the loop its take 30 seconds to be completed:
Then I run your suggestion, the update inside, and it takes me more than 10 minutes.
Why is this happening? Because if you go field by field you waste a lot of time opening and closing the command execution.Of course, my solution is not perfect, if you have too many fields in an update you may get the opposite effect and it may take longer.
Now is more clear?
Bye 🙂
------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------
Hi @Salman Shaik
Understood, I think that your problem was internally when you execute the SQL. Something like SQL syntax error or similar.
I don't understand why it's gives you this error
Maybe something go wrong when you copy and paste
This is the text:
"UPDATE [Hoja1$] SET " & Replace(","&[SQL Statement Fields];",,";"")
I attach you the full process. Check it in your Blue Prism Solution
Hope this helps you!
Bye 🙂
------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------
Understood, I think that your problem was internally when you execute the SQL. Something like SQL syntax error or similar.
I don't understand why it's gives you this error
Maybe something go wrong when you copy and paste
This is the text:
"UPDATE [Hoja1$] SET " & Replace(","&[SQL Statement Fields];",,";"")
I attach you the full process. Check it in your Blue Prism Solution
Hope this helps you!
Bye 🙂
------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------
