NullDisplay - Will substitute all NULL values from ODBC and connectors on the lowest level of data (User defined variable)
NullInterpret - Defined symbol will be interpreted as NULL when it occurs in a text file, Excel file, or an inline statement
OtherSymbol - Define a symbol to be treated as ‘all other values’ before a LOAD/SELECT statement. This is a user-defined variable
When information is joined within your model and there is missing information, as in no matching Keys, you can have that information be explicitly displayed
NullValue - If the NullAsValue statement is used, the defined symbol will substitute all NULL values in the NullAsValues specified fields with the specific string
Set OtherSymbol = +;Concatenate (ProductSupplier)LOAD * INLINE [SupplierKey, AccounName+, unassigned];