APPLY

Options

Script Language: Please specify the scripting language used in the uploaded script.%%00010%%00010%%00010
Data Partition: If other than None, APPLY 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 null 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%%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.
Environment Name: Specify the environment name.%%00010(Assumption: Environment is created outside KNIME)
Script Name: Specify the name of the script and make sure that it is present in the specified environment.
Quotechar: Specifies the character used to quote all input and output values for the script. The default value is double quote
Delimiter: Specifies a delimiter to use when reading columns from a row and writing result columns. Delimiter must be a valid Unicode code point. The default value is comma (,).
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
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 APPLY query.

APPLY

Options

Input Ports

Output Ports

Nodes

Extensions

Links

Download