How To Use DESelect Segment
Troubleshooting
How to resolve “Cannot insert a NULL value into a non-nullable column” error?
"cannot insert a null value into a non nullable column” error is normally encountered in cases where there is a nullable field mapped to a non nullable field in the output step meaning, that you mapped a field with empty value (nullable) into a field in the target data extension where it should always have a value (non nullable), and therefore results cannot be stored how to resolve this? review the target data extension fields looking for red or orange warning signs these signs indicate null fields pointing at non nullable target fields, and will help you find where the error could be in this case, you can either; change the source field that contain null values to a non nullable one, so it doesn’t produce errors when writing the results in the target data extension field in input step, create an 'is not empty' filter on the corresponding field to avoid empty values being written in the target data extension field modify the definition of the target data extension properties by clicking the pencil icon and make the target field nullable by removing the check on the nullable checkbox in case you need to remove and re add the field, please refer to this article docid\ y2nmbgsegctlxl6 eac1s