The Modify stage is a processing
stage. It can have a single input link and
a single output link. It can
also be used to modify schema, Keep or Drop the input columns.If you are using transformer just to drop or change schema of columns then it is better we use modify stage.
Below is the syntax of each of
the operation possible in modify stage and below mentioned syntax can be used
in specification box of modify stage..
Keeping and Dropping Fields :
'keep field1, field2,
... fieldn; '
'drop field1, field2,
... fieldn;'
Renaming
Fields:
‘newField1=oldField1;
newField2=oldField2;...newFieldn=oldFieldn;’
Duplicating...
