Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

input value of any non-nullable primitive field is null, the row of data including that field will be rejected !!

We have "Nullable" parameter under "edit schema" which help us to check/handle the records having null values for a particular field.

I can understand if input value of any non-nullable primitive field is null, the row of data including that field will be rejected.

 

Question/Doubt - what's the purpose/utilization of this property for a non-primitive field ?

i.e.. suppose I have a non-nullable field "state" for which i have few records with Null values which i don't want to process further and want to collect it to check later on ? In this case, we can use the tMap and collect those but, what's the use of the "Nullable" property here (in schema) ?

Labels (2)
1 Reply
Anonymous
Not applicable
Author

The nullable option essentially changes the expected value from being a primitive type (not nullable) to a Class (nullable). So, if you are passing an integer to a column, if the column is not nullable it will be treated as an int, if it is nullable it will be treated as an Integer. 

 

One use of these might be that you have a left outer join in the tMap. Let's say that you are joining to receive an int (primitive). If the join is not met, you will still want the data to be passed on, but you cannot do that if your expected value is primitive for the int. If you select nullable, you can pass null to the column and it will be treated as an Integer. This allows you to carry on with the processing.