Example
If the value of SOURCE_FIELD1 is an ‘A’, then map it to TARGET_FIELD1. Otherwise, map SOURCE_FIELD2 to TARGET_FIELD1.
PROCESS INTO OUTPUT_DATASTORE
SELECT
{
if SOURCE_FIELD1 = 'A'
{
TARGET_FIELD1 = SOURCE_FIELD1
}
else
{
TARGET_FIELD1 = SOURCE_FIELD2
}
}
FROM INPUT_DATASTORE;