With the help of the object transformation you have the possibility to create a modified dataset from a source object and insert it into a destination object.
You can use it to merge several records into one, it is like calculating the summary of values based on some kind of condition.
For an easier way to create your formulas, do not forget to use the formula editor.
Basically there are two types of transformations:
Steps of object transformation:
1. The first step is running the target object formula, which is responsible for changing the target object.
The result of this formula should be an object ID identifying the target object.
If this formula is filled, then the original target object will not be used.
2. The second step may consist of running a pre-formula which always runs before the transformations.
With the help of the pre-formula, you are able to clear the target table or do any kind of initialization.
3. As its name shows, the result of the target ID script should be a data ID, because this ID is going to be used for the next record.
If the result is -1 then a new record will be inserted, otherwise it will use the result ID to update the given record by this ID.
After we take the source object and use the aggregation on it, we can set the source object and the aggregation on the overall page.
With the help of the target ID formula we can reach the aggregation values.
On the other hand, the target ID decides the target record for the calculated values.
4. You can add the calculated values to the target object with the help of the transformation tab by selecting their target entry.
You have the possibility to decide whether you want to insert or not the values from the following cases:
On Insert, On Update, On Insert And Update. By default, the On Insert And Update is selected.
On Insert means that the importing procedure only uses this field if it is inserting a new record.
On Update means that the importing procedure only uses the field if it is updating the record.
On Insert And Update means that the importing procedure uses this field in every case.
In these formulas you can reach the old record's values from the source by using the ORIGINAL_prefix before the entry names.
With the help of this formula you can also set the runtime variables which you want to use in your following steps.
5. The after transformation formula can be the next step of the object transformation.
This formula is executed after every transformed line of data.
Here, we can still reach the values of the aggregations.
With the help of the SetRuntime function you can reach the values of an actual record.
6. The last step consists of an optional act, that is, running a post-formula.
This feature is executed after all the records are calculated and inserted.
You can use it for finishing moves.
For a detailed, step by step presentation of creating a new, event based object transformation, click here.