Alteryx Designer

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

MS SQL Identity Column using In-Database Tools

7 - Meteor

Thanks for the suggestion aelam. The main topic/issue/question at hand however is not "how" to create a Record ID (or similar) using In-DB tools, but rather a workaround for the short coming of the Write-In-DB tool not being able to write data to a table with an identity column (SQL Server itself is the one who populates this field).


Apologies, I should've been more specific and pointed in my original reply. The suggestion by @RodL does work to create a RecordID, but it doesn't help if you have a table with an identity column and don't want to change its current setup. Currently, there is no solution for that. I've suggested it as an idea here: Allow for a column list to be specified when using the Write Data In-DB tool