I’m relatively new to Uipath, and would need some help working with SQL DBs.
Currently I have a problem in loading on DB, a table collected from a scraping, at the beginning of the flow.
my flow collects table DT1, for convenience I have extracted it on Excel.
Elenco.xlsx (8,4 KB)
This table must be overwritten every RUN, so the data can be overwritten every day.
I have to insert the values of the first three columns, on the DB I previously created.
Here is my flow, which gives a syntax error in the UPDATE Query.
Bot2.xaml (273,0 KB)
UPDATE DT1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘NumberSort in descending order =‘0410040094’’ at line 1",
Error in this step:
Can Help Me?