Note: Many of our nodes that previously used Data360 Analyze Script have been deprecated and have been replaced by new Python-based nodes. You may have used some of these deprecated nodes in data flows that were created in earlier versions of Data360 Analyze. It is recommended that where possible you now use the new Python-based nodes. For more information on working with the Python-based nodes, see Python scripting and Transform.
Data360 Analyze Script provides a mechanism for you to provide instruction to nodes to tailor the analysis that is performed at each step in your data flow. When you add Data360 Analyze Script to a node, it is applied to the input data, allowing you to manipulate the input data and output it in the way that you want.
If you're new to Data360 Analyze Script, the following topics will help you to get started:
- Functions, field names and variables
- Output-related tasks
- Comparison and logical operators
- Aggregating data
Data360 Analyze Script-related terminology
| Term | Definition |
|---|---|
| Argument | A specific input to a Data360 Analyze Script function. |
| Boolean | A data type that only has two possible values, true or false. |
| Data type |
Data is organized according to type, for example, numbers, characters or Boolean. |
| Delimiter | A punctuation character or group of characters that separates two names or two pieces of data, for example a comma (,). |
| Execution group | Most nodes which have a Script property (for example, Transform (Deprecated), X-Ref (Deprecated), Lookup (Deprecated), Sort (Deprecated)) process the input records without any concept of grouping. However, certain nodes, such as the Agg Ex (Deprecated) node, have a concept of an "execution group" where the data is processed in chunks. For nodes that have a GroupBy property, such as the Agg Ex (Deprecated) node, the execution group is based on the value specified in the GroupBy property. |
| Execution iteration | An execution "iteration" is a single execution of the Data360 Analyze Script against the input records. An execution group is all of the execution "iterations" which occur in the same group defined on the node. For example, on a node that has input data containing two records, the Data360 Analyze Script will be run against each of the records so there will be two execution iterations within the execution group. |
| Expression | A Data360 Analyze Script statement that is composed of operands and operators. |
| Function | A pre-built instruction that performs an operation and returns a value. |
| Macro | Composed of a number of pre-built instructions, macros allow you to perform a multi-step procedure in one step. |
| Operand | Objects that are used as part of a function to produce a new value. For example, in the expression 5+x "x" and "5" are operands, and "+" is an operator. There is at least one operand in every expression. |
| Operator | A character that represents an action, allowing you to manipulate numbers and text in specific ways. For example, operators are commonly used in mathematics, such as the plus (+) symbol to represent addition, and in logical operations, such as AND. |
| Returned value | When we talk about a function "returning a value", we are referring to the result of an executed function. This could be data that is output to the node's output pin(s), or it could be a value that is produced by a Data360 Analyze Script function that is not necessarily output to the node's output pin(s). |
| Syntax | The spelling and grammar (expected form) of the Data360 Analyze Script language. |
| Variable | A container that holds information. |