mapping.rowUpdate

Updates a row within a mapping table. If the unique combination of keys for one side of the mapping conflict with another row, the other row is removed from the mapping table.

This ensures that there is always a 1:1 mapping between keys on each side of the mapping.

mapping.rowUpdate(mappingName, rowId, leftKeys, rightKeys);

Parameters

• mappingName - An identifier used to find the target mapping.
• rowId - An identifier for the target row.
• leftKeys - An Array of strings representing elements from each of the mapping dimensions on the left side of the mapping table in order.
• rightKeys - An Array of strings representing elements from each of the mapping dimensions on the right side of the mapping table in order.

Example

mapping.rowUpdate("Time to Year and Month", 1, ["FY2017 - Jul"], ["2017", "Jul"]);

All elements specified on each side of the mapping need to be currently existing elements in the mapping dimensions.