Sample projects and automations: How To
The projects in the repository folder Samples\How To
offer solutions to two common data transformation challenges:
Output header and trailer: uses projects and automation to add a header and trailer to a flat file, where the header/trailer and the flat file do not share a schema. The automation _RunUsingUserInput uses a User Interface step to solicit values for temp folder and output file, while _RunUsingExpression defined these values with an Expression step.
Remove non-printing characters: demonstrates how to identify non-printing characters in a data stream and replace them with a "?" character.