DefaultRow

You can define a default or fallback row in a dataset by using the DEFAULTROW feature when a foreign key is missing or invalid.

Defining a default or fallback row serves as a catch-all during joins, aggregations, and data quality checks.

IMPORT SOURCE CHANNELS
DEFINE DATASET CHANNELS_D
 ROWSOURCE CHANNELS;
 THIS = CHANNELS[CHANNEL_ID, CHANNEL_DESC, CHANNEL_CLASS,CHANNEL_CLASS_ID];
 DEFAULTROW
 [
    THIS[CHANNEL_ID,CHANNEL_CLASS_ID] = 999;
    THIS[CHANNEL_DESC,CHANNEL_CLASS] = 'NO CHANNEL';
 ] 
END 

In this example, a synthetic row with the constant values of 999 for the columns CHANNEL_ID,CHANNEL_CLASS_ID, and “NO CHANNEL” for the columns CHANNEL_DESC,CHANNEL_CLASS is inserted using DEFAULTROW.