Creating a Job for aggregating values based on dynamic schema
Create a Job to aggregate some task assignment data in a CSV file based on a dynamic schema column using the tAggregateRow component, then display the aggregated data on the console and write it into an output CSV file.
Procedure
- Create a new Job and add a tFileInputDelimited component, a tAggregateRow component, a tLogRow component, and a tFileOutputDelimited component by typing their names in the design workspace or dropping them from the Palette.
- Link the tFileInputDelimited component to the tAggregateRow component using a Row > Main connection.
- Do the same to link the tAggregateRow component to the tLogRow component, and the tLogRow component to the tFileOutputDelimited component.