SCRIPT

0 ×

Options

Script Language

Please specify the scripting language used in the uploaded script.%%00010%%00010%%00010

Data Partition

If other than None, SCRIPT will partition the data sent to your script. In Vantage, instances of your script will execute with different data partitions as input until all partitions are exhausted. The column values option determines partitioning by means of different values in one or more columns (note: This option corresponds to using the PARTITION BY clause in SQL). The Database AMP hash option partitions data in a different way, where data are distributed to Database AMPs based on AMP hash values in one or more columns (note: This option corresponds to using the HASH BY clause in SQL.

Nulls Listing

[Optional] On selecting FIRST, the nul values will be listed first and on selecting LAST, all the null values will be added at the end.By default,the option is N/A and nulls listing will be ignored.%%00010

Arguments

[Optional] Specify any additional input arguments, if needed by your script. Each new argument should be seperated by a comma.%%00010

Column name(s) to partition by

Specify column names for the partition task. Each new argument should be separated by a comma.%%00010

Column name(s) and sequence to order by

[Optional] Enter column names and their order, separated by spaces, to determine the row sequence within partition groups. Use 'ASC' for ascending and 'DESC' for descending. Use commas and new lines for multiple columns.%%00010

Output Columns

Please specify the name of each output argument generated by your script. Ensurethat the output column names and their respective data types are separated by a space, with each new argument separated by a comma.

STO Database

Specify the name of the STO database.

Input Column(s)

[Optional] If you leave blank, then your script receives as input all columns in the recipe input dataset.

Conditions

[Optional] Specify in SQL format any conditions that your input data must satisfy (Note: This option corresponds to using the WHERE clause in SQL).%%00010

Script Name

Enter the name of the script which is present in the specified schema

Output Schema

Specify the name of the output schema.

Output Table

Specify the output table where the results will be stored following the execution of the STO query.

Nodes

• String Configuration10 ×
• DB SQL Executor (Labs)3 ×
• Single Selection Configuration3 ×
• Python Script2 ×
• Component Input1 ×
• Show all 11 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Database
• FeatureKNIME Python Integration
• FeatureKNIME Quick Forms

Links

• No links available