Hi @Rajiv Tarafdar ,
checkout below link for resolution,
https://apeople.automationanywhere.com/s/question/0D52t00001DpGRNCA3/i-c-onnected-csv-file-using-microsoft-text-connection-string-in-a360-using-database-insertupdate-command-i-tried-to-update-the-csv-file-but-it-is-showing-syntactical-error?s1oid=00D90000000gDTdamp;OpenCommentForEdit=1&s1nid=0DB6F000000oMPS&emkind=chatterPostNotification&s1uid=0056F00000ATXY5&emtm=1644922105579&fromEmail=1&s1ext=0
Hi @Rajiv Tarafdar ,
You can't update records in CSV unless it involves a JOIN operation.
Here is the syntax for updating records in CSV using JOINs:
UPDATE Movies$$] AS t1
INNER JOIN ON t1.>Title]=t2.]Title] SET t1.>Title]= t2.=Profit] I haven't tried using Self Joins, maybe try giving that a try and see if it works out for you? Kind Regards, Ashwin A.K
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.