Transformation rule

A transformation rule describes how data is reshaped or calculated when moving from source to destination. It can map fields, change data types or derive a destination value from inputs, for example. The business meaning of the inputs determines which rule fits.

Describe a quantity conversion precisely

In a fictional exchange, 2 cartons containing 6 items each correspond to a destination quantity of 12 items. The rule may apply only when the packaging unit and pack factor are known for this item. If the factor is missing, the case needs clarification; an unchecked substitute value would invent a quantity.

Check calculation and validity separately

Microsoft shows derived columns that generate new values or modify existing fields. Such functions implement agreed logic. They do not decide for themselves whether the conversion is valid for the business. Record the prerequisites, expected result and behaviour when information is missing before checking sample data against the rule.

Sources

• Microsoft Learn: Derived column transformation