REFORMAT - from file to database

francoise.gerard

• August 13, 2008 00:00

• Answered

Follow

Hi,

I'm newbie in cloverETL.
I'm trying to integrate some data from text file into a table from a database.

I success in copying text file in another textfile, and a table in another table.

For the copy from file to database, I'm using a REFORMAT transformer, but the transformed record number is always 0.
I'm using the "easy transformation mapping".

Can someone help solving this? What am i missing?


Françoise

• 

  jurban

  • August 13, 2008 11:30

  0

  Comment actions Permalink

  Hi,
  can you please post the graph, or at least the simple transformation mapping? how many records are read as input of the reformat?
  
  Jaro
• 

  francoise.gerard

  • August 13, 2008 11:55

  0

  Comment actions Permalink

  I tried the "clover" transform as this :
  
  function transform() {
  $0.objectId := str2num($0.ID_KF);
  $0.illustrationName := $0.Nom;
  $0.switchCcy := $0.DeviseS;
  $0.productName := $0.NomProduit;
  $0.referenceCcy := $0.DeviseP;
  }
  
  and now it works!
  
  Maybe the "easy transform mapping" is only to map same data type (no string to num conversion) ?
• 

  jurban

  • August 13, 2008 12:04

  0

  Comment actions Permalink

  Hi,
  easy transformation language can do some type conversions, but not all (string to num probably does not work automatically). the easy transformation language (or as we call it Clover Transformation Language Lite) is basically just a simple macro language for Java, so everything except ${field) and @{field} is normal Java source...
  
  Jaro

Please sign in to leave a comment.