Creating custom functions

In this recipe, we will get familiar with a Smart Editor tool available in Designer to help you write your scripts or functions in a convenient way.

We will create a new function that can be executed either within a script or within a dataflow. This function accepts two parameters: date value and number of days. It then adds the number of days to the input date and returns the result date.

How to do it…

  1. Open Designer and go to Tools | Custom Functions… from the top level menu:
    How to do it…
  2. In the opened window, right-click in the area with the list of functions and choose New….
  3. Choose the name of the new fn_add_days function and populate ...

Get SAP Data Services 4.x Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.