Hi All,
Thank in advance for helping us resolve the following issue.
In our POC project, we must take the value of a product weight from source table and store it in destination table after some conversion. The schema of the source and destination table structure is given below with sample records. The weight unit in the source table given by the “WEIGHT_UNIT_OF_MEASURE” field can have the following values: “Kilogram”, “Centigram” or “Milligram”.
In the destination table the corresponding is “WEIGHT_IN_KILOGRAM” and weight is always expressed in “Kilogram”.

Source Table:
ID, WEIGHT, WEIGHT_UNIT_OF_MEASURE
A; 5; Kilogram
B; 45; Milligram
C; 30; Centigram

Destination Table
ID, WEIGHT_IN_KILOGRAM,
A; 5
B; 0.045,
C; 0.30

The issue can be expressed in pseudo code as follow:
if (SourceTable.WEIGHT_UNIT_OF_MEASURE == “Centigram”)
    DestinationTable. WEIGHT_IN_KILOGRAM = SourceTable.WEIGHT/100;
else if (SourceTable.WEIGHT_UNIT_OF_MEASURE == “Milligram”)
    DestinationTable. WEIGHT_IN_KILOGRAM = SourceTable.WEIGHT/1000;
else DestinationTable. WEIGHT_IN_KILOGRAM = SourceTable.WEIGHT;

Is there any way to do such a conversion using the tMap? We are running TOS 2.3.0.M2_r7640 and Java.