REFORMAT - from file to database

CloverDX Platform
1

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

2

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

3

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) ?

4

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