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.png
- Alteryx Designer
- 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