Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Knowledge Base

Definitive answers from Designer 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

No ratings