convert string to datarecord

peterpan

• November 17, 2014 00:00

• Answered

Follow

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

  • November 18, 2014 14:47

  0

  Comment actions Permalink

  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,
• 

  peterpan

  • November 18, 2014 16:27

  0

  Comment actions Permalink

  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

  • support.PNG
• 

  peterpan

  • November 18, 2014 16:29

  0

  Comment actions Permalink

  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

  • support.PNG

Please sign in to leave a comment.