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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Cannot output to SQL Server due to identity column?

Meteor

I am trying to insert output to a SQL Server database table and running into a problem. Alteryx is attempting to insert [NULL] into my table's auto-incrementing identity column. I then receive the SQL error:

 

Cannot insert the value NULL into column ...

 

How do I stop Alteryx from trying to insert null into columns that aren't a part of my workflow's dataset?

Bolide
Bolide

Hello @nrossin 

 

Considering the column is auto-incrementing, the best way is to de-select the column using 'Select' tool before the Data is getting pushed to the SQL server. This way no value will be forced to your auto-incrementing column and the rest of the data load will not be impacted too!

 

Hope this helps,

 

Thanks,

Yug 

Labels