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

  1. Can be either a Sub or a Function.
  2. Must have a method header and footer.
  3. Can have arguments.
  4. The calling convention for a ‘Common Function’ is exactly as any other Sub or Function.