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?
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?
-
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,
Please sign in to leave a comment.
Comments 2