my task is to transform values which are in a source table and to write them in a target table which has a predefined template structure.
i used the following component structure (screenshot) to fulfill this task.
For transforming the input data records i tried to use java. i try to access to the input data records by
converting the input array in string. Afterwards i want to convert it back and write it in a output table. The conversion to
String works fine, the other way seems not to work.
Besides: Do you know how to keep the target template structure? Always when i write some Attributes in the target table, i get the simple cloveretl sheet structure: Header = Name of Attribute, Body= Values. The issue is that i have some meta information in the target sheets, which are always deleted when i write any data in the target sheet.
- support.PNG (22.98 KiB) Viewed 2008 times