tDenormalizeSortedRow
Synthesizes sorted input flow to save memory.
tDenormalizeSortedRow combines in a group all input sorted rows. Distinct values of the denormalized sorted row are joined with item separators.
tDenormalizeSortedRow Standard properties
These properties are used to configure tDenormalizeSortedRow running in the Standard Job framework.
The Standard tDenormalizeSortedRow component belongs to the Processing family.
The component in this framework is available in all Talend products.
Basic settings
Properties | Description |
---|---|
Schema and Edit Schema |
|
Input rows count |
Enter the number of input rows. |
To denormalize |
Enter the name of the column to denormalize. |
Advanced settings
Properties | Description |
---|---|
tStatCatcher Statistics |
Select this ckeck box to collect the log data at component level. |
Global Variables
Variables | Description |
---|---|
Global Variables |
ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box. NB_LINE: the number of rows read by an input component or transferred to an output component. This is an After variable and it returns an integer. A Flow variable functions during the execution of a component while an After variable functions after the execution of the component. To fill up a field or expression with a variable, press Ctrl+Space to access the variable list and choose the variable to use from it. For more information about variables, see Using contexts and variables. |
Usage
Usage guidance | Description |
---|---|
Usage rule |
This component handles flows of data therefore it requires input and output components. |