This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Debating whether or not to upgrade to the latest version of Alteryx Designer?
Output Data to SQL.
Alteryx is creating output table with fields set with NULL option.
How to set certain fields as NOT NULL in output table in alteryx?
Check this topic: Create Database Table Primary Key in Alteryx
You need to use Post-SQL statement:
ALTER TABLE YourTable
ALTER COLUMN YourColumn NOT NULL;
Every time i run the workflow will it execute the alter query?
Since in the first execution the column was already created.