How Do I Prevent Lost Columns?

Log data might have a field with a value (such as Customer="Acme"), or a field with no value (such as Customer=""), or no field at all. When you need to chart or evaluate that field or column, missing data can be frustrating. To avoid this problem, use if_null.

Use if_null to get the value from Prospect if there is no value for Customer. Note that both values must be the same type.

make_col organization:if_null(string(Customer), string(Prospect))

Use if_null to set the value to Unknown if there is no value for PrimaryContact.

make_col Contact:if_null(string(PrimaryContact), "Unknown")