SET Instructions in Transformation Formulas
You can configure the HCM Data Loader Transformation Formula to add SET instructions. On the HCM Data Loader DAT files, add the SET instructions before the METADATA instruction.
SET instructions are optional control commands that alter the default processing of the HDL file in which they appear.
Let's consider these examples.
Example 1
You can use the ENABLE_INCREMENTAL_LOAD_EVENTS
set command to enable payroll events on the data that's loaded using
SET instructions.
Here's the formula to enable the payroll events:
ELSE IF OPERATION = 'SETINSTRUCTIONS' THEN
(
SET1[1] = 'PersonalPaymentMethod' /*FileName*/
SET1[2] = 'ENABLE_INCREMENTAL_LOAD_EVENTS Y'
RETURN SET1
)
Example 2
Let's assume that you're loading personal payment method data and you want the name of the personal payment method to have a pipe. The name of the personal payment method should be PPM|1.
Here's the transformed HCM Data Loader file with a single line to load the personal payment method data with delimiter as pipe.
METADATA|PersonalPaymentMethod|EffectiveStartDate|PersonalPaymentMethodCode|AssignmentNumber|Percentage|ProcessingOrder|OrganizationPaymentMethodCode|PaymentAmountType|LegislativeDataGroupName
MERGE|PersonalPaymentMethod|2018/04/04|PPM\|1|E300100006342154|100|999|PM US Sun Power Check |P|PM US Sun Po
Here's a sample snippet of the formula text to load personal payment method and user defined table:
ELSE IF OPERATION = 'SETINSTRUCTIONS' THEN
(
SET1[1] = 'UserDefinedTable' /*FileName*/
SET1[2] = 'FILE_ESCAPE \'
SET2[1] = 'PersonalPaymentMethod' /*FileName*/
SET2[2] = 'FILE_ESCAPE \'
RETURN SET1, SET2
)