To use the results of a vertical macro in a mapping, configure a field rule to include the output fields in the downstream transformation.
Because an expression macro represents fields that are not explicitly defined until run time, you need to configure the downstream transformation to include the output fields of a vertical macro.
A macro input field named %InputDates% represents the following source fields for a macro that converts the data to the Date data type:
The macro output field uses the default naming convention: <macro input field>_out. To use the Date fields that the macro generates, create a Named Field rule in the downstream transformation to include the following fields:
After you create the field rule, you can use the fields in expressions and field mappings in downstream transformations.