Allows you to rename, remove, reorder, or add columns/properties of your ingoing data.
This transformation works with objects and dynamic ExpandoObjects as input data type.
It will always convert the input type into an ExpandoObject as output.
Added properties are appended after the reorganized input columns.
A non-empty AddColumns list replaces AddColumn attributes.
If ValueFunc is set, it replaces the constant value.
Defines new properties appended to the output object, in list order.
A non-empty list replaces AddColumn attributes on the input type.
If an entry has ValueFunc set, that function replaces its constant value.
Instead (or additional) to existing column removing provided via the RemoveColumns property or
the RemoveColumn attribute, you can define your own function to decide if a property should be removed.
The rename columns defines how existing properties/columns are renamed.
For objects and dynamic object provide a mapping with the old and the new name.
The mapping can also be automatically retrieved from RenameColumn attributes on the properties in strongly typed objects.
Instead (or additional) to existing column renaming provided via the RenameColumns property or
the RenameColumn attribute, you can define your own renaming function.
It is called for each column in each row from the input, and allows you to transform the column/property name into
a different property name.
Instead (or additional) to existing column reordering provided via the ReorderColumns property or
the ReorderColumn attribute, you can define your own function to set the new index of a property.
If an error occurs in the component, by default the component will throw an exception and stop execution.
If you use the error linking, any erroneous records will be caught and redirected.