How to Add a field

CloverDX Platform
1

I’m coming from informatica and still getting a handle on CloverETL

How can i add a field? i have a flat file that comes in with a specific number of fields, however in the table i load to, i want a field that indicates a Processed flag. which transformer will allow me to add a field that simply loads “Y” into the table?

2

Hello Mohamedosharif,
I would suggest using the Reformat component to achieve your desired result. Create a copy of the metadata on the Reformat input edge, add a new “processed” field to this new metadata and assign it to the Reformat output edge. The transformation definition inside the Reformat component would resemble to following:

$out.0.* = $in.0.*;
$out.0.processed = "Y";

Kind regards,

3

thank you! this worked beautifully. i’m still getting used to this.