How to Clear a Column Selection in a Custom Script in a Data Flow in Oracle Analytics (Doc ID 2827258.1)

Last updated on DECEMBER 14, 2021

Applies to:

Goal

In DV, a custom script can be invoked in a Data Flow to perform some action(s). The general steps are:

1. Write some custom code (in Python, for example) and embed it in a pre-defined XML format
2. Upload the custom script via /dv > Create > Script
3. Create a Data Flow > Add a Data Set > Add the "Apply Custom Script" step and select the uploaded custom script > Specify Inputs / Parameters / Outputs for the script, as applicable
4. Add the "Save Data" step
5. Save and Run the Data Flow

In the "Apply Custom Script" step, if a column has been selected in error as a Parameter for the script, how can it be de-selected?

For example:

See the DV Unpivoting sample script at Oracle Analytics Examples Library

In the Apply Custom Script step in the Data Flow, see the "Mapped Attribute 2" parameter is optional > Click on the "Select a column" link and choose any column from the Data Set > Click on the column name and see you can change it to any other column.

How to clear any selection so there is no column specified for the "Mapped Attribute 2" parameter?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.