Common Functions
This is an incredibly useful resource.
Common functions allow you to setup a shared library of VBScript functions which can be called from any VBScript enabled transform/task, such as the Map, Filter or Aggregate transforms.
Setup > common Functions
Common functions can:
- Embed common logic which can be used throughout an integration or across multiple integrations.
- Handle particularly complex functions, so they can be easily edited.
- Use these functions in areas that only support in-line VBScript, such as the File Name field on a File IO Contoller.
Common Functions have many properties
- Can be either a Sub or a Function.
- Must have a method header and footer.
- Can have arguments.
- The calling convention for a ‘Common Function’ is exactly as any other Sub or Function.