Question

Syntatical Error while using the Update with Select Query

  • 4 August 2022
  • 1 reply
  • 60 views

Hi Everyone,

I am trying to use the update query with select statement in automation anywhere. I have 2 different tables(2 excel sheets). I need to update one column by comparing the colum names [client num]of first table with RAFT Client # column in the second table. 

If the client value matches, then bot needs to update optin column

For this I have used the Insert/Update/Delete Command, and i used the below query :

 

UPDATE [ASO Output$] SET [ASO Output$.Opt In?]=[Sheet1$.Max_ASO Vendor Fee Pass Through] FROM (SELECT [Sheet1$.Max_ASO Vendor Fee Pass Through],[Sheet1$.RAFT Client #] FROM[Sheet1$] AS [Sheet1$] WHERE [SHEET1$.RAFT Client #]=[ASO Output$.CLient_Number];

 

But I can't able to get the proper result, Syntatical error occured. Can anyone help me to resolve this issue

 

Thanks,

Gayathri M

 


1 reply

Userlevel 4
Badge +8

Hi @Gayathri M​ ,

 

Good Day!

 

Please refer the below KB article for the reported error and follow the steps:

https://apeople.automationanywhere.com/s/article/Excel-as-Database-commands-fail-to-execute-with-Syntactical-Error/p>

https://apeople.automationanywhere.com/s/article/There-is-a-syntactical-error-in-the-SQL-statement-SQL-statement-got-timed-out/p>

 

If you are still facing an issue then please create a support case

 

How to create a support case :

https://apeople.automationanywhere.com/s/article/How-to-create-a-support-case-in-service-cloud/p>

if you don't have access to the above link, email the AA Support team "apeopleopsteam@automationanywhere.com" to get the access.

 

Reply