community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

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.
Alt01.PNG

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

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?

 

Cheers,

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.

Labels