@BIDEV3421    This property is for the opposite of what you want. The value of this property is what hive shows when the source day has a null value.   I don't think there's a property to do what you want, but you can use an expression like the following in your select:   case when mycol = ' ' then NULL else mycol end   Cheers Andre       ... View more