convert string to datarecord

Discussion on developing CloverETL engine, transformation components etc.

peterpan
Posts: 6
Joined: Mon Nov 17, 2014 2:59 pm

convert string to datarecord

Postby peterpan » Mon Nov 17, 2014 3:11 pm

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..

imriskal
Posts: 383
Joined: Wed Aug 15, 2012 8:18 am

Re: convert string to datarecord

Postby imriskal » Tue Nov 18, 2014 3:47 pm

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,
---
Lubos Imriska
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support

peterpan
Posts: 6
Joined: Mon Nov 17, 2014 2:59 pm

Re: convert string to datarecord

Postby peterpan » Tue Nov 18, 2014 5:27 pm

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
Attachments
support.PNG
support.PNG (22.98 KiB) Viewed 1255 times

peterpan
Posts: 6
Joined: Mon Nov 17, 2014 2:59 pm

Re: convert string to datarecord

Postby peterpan » Tue Nov 18, 2014 5:29 pm

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
Attachments
support.PNG
support.PNG (22.98 KiB) Viewed 1255 times