Problem:
--------

When I generate my outbound formulas, I do not get an error, 
but I do get an error when I generate my data.  Here is my 
formula:

if |ORDCUST| <> ‘’ then |ORDCUST| else ‘NOCUST’

Additional information:
LEVEL = 2
|ORDCUST| is defined as customer number on order.

Whether the order record is there or not, I still want to 
generate data. In order to correct the missing order’s 
customer number in my generated data, I can type in the 
customer number after the generation has occurred, should 
the order record have been deleted. 

How do I handle this situation in my formula?

Solution:
--------

If the order is available for this level, then check your 
map to see that the appropriate level is associated with 
this segment.  Maybe you have accidentally overwritten the 
level.  Correct the level if that is the case.  

If normally the order is available but the order might have 
been deleted for some unknown reason, you can still generate 
your outbound data without errors.

Here’s how to change the formula in order to generate data 
for this special case whereby you still want to generate 
data even if the keyword’s record does not exist (the order 
record in this example):

if (available |F:ORDCUST| and |ORDCUST| <> ‘’) then 
|ORDCUST| else ‘NOCUST’

In English the above means: If the order record exists and 
the customer number on it is not blank then use the value in 
the order’s customer field, otherwise use the value 
‘NOCUST’.

TIP: Use |F:keyword| to indicate that you want to refer to 
the file name of that keyword.  Add brackets to be more 
concise.