Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Create table with Data Type NOT NULL

Highlighted
6 - Meteoroid

In SQL you can create columns with the condition NOT NULL to prevent null values being added to the table. 

 

E.g. 

 

CREATE TABLE schema.table (

    Name varchar(12) NOT NULL,

...

)

 

I have used the text input and select tools to add columns and data type but can't find away to replicate the above. Once the table has been created I want it to error if you try to submit a NULL value for that column.

 

Any help would be appreciated, thanks.

Highlighted
11 - Bolide

I would recommend filtering out nulls using a filter tool before pulling the data into the rest of your flow.

Highlighted
6 - Meteoroid

Thanks for the response, I need it to error when NULL values are trying to be added, rather than ignoring them. The 'Test' tool allows me to do that when ingesting the actual data but it would have to be added to any workflow I use which I want to avoid.

 

Labels