yes, I need to update the table, but I have a problem with technical parts - how to do it all at Uipath. Use query / non query activity? And how to fill panel properties also. I was trying to set it up for 3 hours but with no results.
In that activity properties:
Connection Config - Open a connection using the connect activity and pass in the existing database connection from there.
Input -
-SQL = Update SQL statement. Your query will look something like below:
“UPDATE [TABLE] SET Amount = ‘55’, Status =‘Active’ WHERE invoice_key = @Invoice_Key AND company_code = @Company_Code”
-Parameters =
- Name = @Invoice_Key / Value = varinvoice_key
- Name = @Company_Code / Value = varcompany_code
Output -
- Affected Records -Returns number of updated items
Hope that helps, read the link to understand the activity more
I am trying to add columns in EXCEL.By connecting excel as a database.
I am using ALTER statement to add column.
ALTER TABLE [TABLE_NAME$] ADD [COLUMN_NAME] VARCHAR(100);
but this is not working.
can you help me with this.
Thanks in advance.
Yes, I know that we can use add data column activity to add new column in Excel.
but what I am automation is complex so I thought of using Excel as a database.
There are multiple other things which I am doing and are working fine like Select Query is working but to add column using Alter Query is not working.