Scripting Inputs and Outputs

Whatever kind of script you're using, you must configure the input and output. Input refers to the columns you are parsing from the table to the script. Output refers to the columns that are produced by the script, and whether these columns should be placed in the existing table or a new one.

When you download a script from the Marketplace, Pyramid automatically detects the inputs and outputs. When writing a script of choosing a shared script, you'll need to configure the input and output columns yourself. You also have the option to use to let Pyramid auto-detect the output from the script.

Input Window

The Input window displays the column inputs for the current script. Each row in the listing represents a column:

• Data Frame: the data frame of the column. The first character must be an English letter, and any subsequent characters can include letters, numeric digits, or underscores; spaces are not supported for this field.
• Type: the data type of the column.
• From: the column to input.
• To: the target/ object in the script. The first character must be an English letter, and any subsequent characters can include letters, numeric digits, or underscores; spaces are not supported for this field.
• Required for Prediction: only relevant for learn and predict scripts.

When downloading a script from the Marketplace, Pyramid detects the input columns automatically. When writing your own script, or selecting a shared script, users must manually add the output columns to the Output window.

To edit a column output, click on it to open its fly-out menu (blue highlight below). To delete a column, click its delete icon, and to add a column, click the plus icon (green arrow below). To add all columns in the table as inputs, click 'Add all' (yellow arrow below).

Output Window

The Output window displays the output of the current script. Each row in the listing represents a column:

• Data Frame: the data frame of the column. The first character must be an English letter, and any subsequent characters can include letters, numeric digits, or underscores; spaces are not supported for this field.
• Column Name: the name of the column.
• Type: the data type of the column.
• Size: the size of the column

To edit a column output, click on it to open its fly-out menu (green arrow below). To delete a column, click its delete icon, and to add a column, click the plus icon.

When downloading a Marketplace script, Pyramid detects the output automatically. When writing your own script, or selecting a shared script, users must manually add the output columns to the Output window.

Auto Detect

Click 'Auto Detect' from the Output window to open the 'Auto-detect output columns' dialog, where you can enter the data frame. Pyramid will then detect the given data frame and its columns in the script, and add them to the output list

• Click here to learn more about data frame support.

Add Columns

To add columns to the output list manually, click the plus icon (green arrow below). You need to specify the data frame, column name, and data type.

Output Options

There are two options for where to store the output column(s) generated by the script:

• Add to Existing Table: add the output column(s) to the existing table (the table to which the scripting node is connecting).
• Create New Table: create a new table and add column outputs to that new table.