HCM Cloud Additional Earnings Integration with EPM Enterprise WFP module
SummaryIn DM, using mapping keeps appending to new Earnings[N] members. Data uniqueness on Property dimension via LOOKUP in target is unclear.
I'm trying to map the following multi-column file to the EPM Enterprise WFP module.
Here's the exported results in DM Workflow
Here's the data load configuration in Planning
Here's my import format
Here's my LINEITEM Account Data Mapping.
Here's my Data Load Rule for this location
For the first run, the LINEITEM mapping work's fine. Smart View results are:
However, when I re-load the same file with no changes, I expect LINEITEM mapping to overwrite, not Append to new Account members (Earning3 and Earning4).