Loading a transformation script

If there are published transformation scripts available, you can load them into a project and run them against a similar project data set, or if the data sets are different, you can modify the script as necessary.

To load a transformation script:

  1. In the Catalog, select a project.
  2. Select Transform.
  3. Click the icon to view the transformation script.
    For example:
    Shows the icon you click to display the transform script.

  4. From the transformation script menu, select Load Script.
    For example:
    Shows the transform menu with its three menu options available.

  5. On the Load Script dialog, select the name of the script you want to load. By default, you see all scripts that were created for the current data set.
    You may need to deselect Filter to current data set in order to show all scripts that are available to Studio.
  6. Click Append to append the script to the end of the existing transformation steps, or click Replace to overwrite the existing script.
    The Replace option replaces the old script with a new script and also reverts any changes that were committed using the old script. The revert operation effectively resets the data set to a point before any transforms were committed. You then commit the new (replaced) script against the project data set.