Transformation Dynamic Action

About

The “Data Transformation action” is used to modify or manipulate data within a workflow. It enables you to convert, reformat, or map data from one structure or format to another. This action is often used to ensure that data is in the correct format for the next step in the workflow or to meet specific requirements for integration with other systems. Common transformations include changing data types, merging or splitting data fields, and applying calculations or conditions.

To create a new Transformation Action, Drag and Drop it from the Object tree.

Metadata tab

1. The Write Variables option ensures that the “Package Action” logs the variable values into the “Action vars before log file” before the action is executed and logs the updated variable values into the “Action vars after log file” after the action completes.
2. This option is typically used for debugging and is not recommended in a production environment.
3. It can be globally disabled through the options dialog .

Parameters tab

Selecting Transformation

Variables tab

The Variables tab defines which variables are updated during the execution of the action.

Calculated Transformation example

Pascal

begin
 if DayOfWeek(Now)=3 then
    begin
     Result:=1917;
    end
 else
    begin
     Result:=1968;
    end;
end;

Python

import datetime;
if datetime.datetime.today().weekday()==0:
   Result.Value=3917
else:
   Result.Value=3918

Related Actions

1. Block Transformation Action
2. Import Action

Useful Links

• Debugging Actions
• Working With Variables
• Designing Transformations
• Mapping Screen