Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

SQL "Update... where [field] = [value]" in Alteryx

6 - Meteoroid

OK, I might be doing something really stupid here, but it has been driving me crazy for a few hours now.

After a whole series of steps to pull text files off an SFTP server and process their contents, the final step is to update a control table and change the "processed_flag" value from 0 to 1.

For some reason this does not work.

A Browse node shows that the correct data is available.

But the Output data node is returning this error. It looks like the required values are not being parsed into the SQL statement (...?)

Other notes...Filename is the primary key of the control table. I am using ODBC.

Any ideas on what could I be doing wrong?

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Manning_Oz 


How's your update query in your Output Tool?


Have you tried to run a select command with the same parameters to check it out?



6 - Meteoroid

All good, I finally figured out my mistake. There were two columns, one with the file extension included and one without, and I was making the comparison using the wrong columns.


The lesson here is that sometimes you can get too focused on the wrong thing, and forgot to cover the basics. Oh well.