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 generally available.
Basic settings
|
Schema and Edit |
A schema is a row description, it defines the number of fields to be processed and Click Edit schema to make changes to the schema.
Click Sync columns to retrieve |
|
|
Built-in: You create the schema |
|
|
Repository: The schema already |
|
Input rows count |
Enter the number of input rows. |
|
To denormalize |
Enter the name of the column to denormalize. |
Advanced settings
|
tStatCatcher Statistics |
Select this ckeck box to collect the log data at component |
Global Variables
|
Global Variables |
ERROR_MESSAGE: the error message generated by the
NB_LINE: the number of rows read by an input component or A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Usage
|
Usage rule |
This component handles flows of data therefore it requires input |
Scenario: Regrouping sorted rows
This Java scenario describes a four-component Job. It aims at reading a given
delimited file row by row, sorting input data by sort type and order, denormalizing all
input sorted rows and displaying the output on the Run
log console.
-
Drop the following components from the Palette onto the design workspace: tFileInputDelimited, tSortRow,
tDenormalizeSortedRow, and tLogRow. -
Connect the four components using Row Main
links.
-
In the design workspace, select tFileInputDelimited.
-
Click the Component tab to define the basic
settings for tFileInputDelimited.
-
Set Property Type to Built-In.
-
Fill in a path to the processed file in the File
Name field. The name_list file used in this
example holds two columns, id and first name.
-
If needed, define row and field separators, header and footer, and the number
of processed rows. -
Set Schema to Built
in and click the three-dot button next to Edit Schema to define the data to pass on to the next component.
The schema in this example consists of two columns, id and
name.
-
In the design workspace, select tSortRow.
-
Click the Component tab to define the basic
settings for tSortRow.
-
Set the Schema Type to Built-In and click Sync columns
to retrieve the schema from the tFileInputDelimited component. -
In the Criteria panel, use the plus button
to add a line and set the sorting parameters for the schema column to be
processed. In this example we want to sort the id columns
in ascending order. -
In the design workspace, select tDenormalizeSortedRow.
-
Click the Component tab to define the basic
settings for tDenormalizeSortedRow.
-
Set the Schema Type to Built-In and click Sync columns
to retrieve the schema from the tSortRow
component. -
In the Input rows countfield, enter the
number of the input rows to be processed or press Ctrl+Space to access the context variable list and select the
variable:tFileInputDelimited_1_NB_LINE. -
In the To denormalize panel, use the plus
button to add a line and set the parameters to the column to be denormalize. In
this example we want to denormalize the name column. -
In the design workspace, select tLogRow and
click the Component tab to define its basic
settings. For more information about tLogRow,
see tLogRow. -
Save your Job and press F6 to execute
it.
The result displayed on the console shows how the name column was
denormalize.