Convert string to datarecord

CloverDX Platform
1

hey guys,

i need to transform a value from a source excel table to a target table.
my approach to get the source values as string is to use the transform function and use the source array (arg0[0]).
how i can to write the modified source value in the target table using java?

best regards…

2

Hello,

Where is the target table, please? It’s not clear from your description. And why do you not use any writer component and you are trying to use Java code instead? Could you please describe your task in more details?

Thanks,

3

hey,

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.

Thx

4

hey,

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.

Thx