Treatment of NULL and empty string values.

PowerSuite does not distinguish between absence of value (NULL) and attribute value represented as an empty string. In the case attribute value is missing it is treated as ttattribute having an empty string value.   

The following example demonstrates treatment of absence of value for City attribute.

CASE

          WHEN [City] = '' THEN 'No Value for City provided'

          ELSE 'Unknown'

END