Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

Defect GDC-2512 Error: "No value column to update"

londonhanson
Alteryx
Alteryx
Created

Error: “No Value Column to Update”

 

Environment Details

When attempting to output to SQL table with only one column, the "No value column to update" error is thrown.

 
Conneccimage.pngimage.png
  • Alteryx Designer
    • Version: 2022.1
  • SQL Server
  • ODBC driver for SQL Server


Cause


This error occurs when the SQL table contains only one column, and it happens with Append Field Map in the Output Data tool configured with Map By Name or Custom Mapping.



Resolution


Defect GDC-2512 has been created for this issue and will be addressed in a future release of Designer.

Additional Resources