| Search: |
 | Anonymous | Login | Signup for a new account | 2010-09-03 07:38 CEST |
| Main | My View | View Issues | Change Log | Roadmap | Summary | Docs |
| Viewing Issue Advanced Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||
| ID | Category | Severity | Reproducibility | Date Submitted | Last Update | ||
| 0002299 | [Talend Open Studio] Perl components | feature | always | 2007-10-19 10:20 | 2007-11-22 09:22 | ||
| Reporter |
rbillerey |
View Status | public | ||||
| Assigned To | rbillerey | ||||||
| Priority | normal | Resolution | fixed | Platform | |||
| Status | closed | OS | |||||
| Projection | none | OS Version | |||||
| ETA | none | Fixed in Version |
2.3.0M1 
|
Product Version | |||
| Target Version | Product Build | ||||||
| Summary | 0002299: New component tPivotOutputDelimited | ||||||
| Description |
The component performs a crosstable aggregation. As the output column number is only known at runtime, this is an output component. We specify 3 columns from input schema : - a "rows" column - a "columns" column - a "calculation" column An aggregation operation is specified : sum, count, min, max Attached file shows input flow and the ouput result. |
||||||
| Steps To Reproduce | |||||||
| Additional Information | |||||||
| Tags | No tags attached. | ||||||
| generated language | perl | ||||||
| workload (in half days) | |||||||
| Attached Files |
 pivot.xls [^] (27,648 bytes) 2007-10-19 10:20 |
||||||
|
|
|||||||
 Relationships |
|||||||||||
|
|||||||||||
|
Notes |
|
 (0004829)rbillerey (developer) 2007-10-24 13:56 |
To perform the crosstable calculation we define, based on the input schema : - a pivot column : the distinct values of this column produce the columns headers - groupby columns: these columns are concatenated and the distinct values produce the rows headers - an aggregation column and an aggregation function ( sum, count, min, max, first, last ) The crosstable calculation does not break the input sort order. If you want (2007, 2006, 2005) you have to sort the input according to that order. |
|
(0004830) rbillerey (developer) 2007-10-24 14:07 |
Feature added on trunk in [Subversion, tos] r6525 |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2007-10-19 10:20 | rbillerey | New Issue | |
| 2007-10-19 10:20 | rbillerey | Status | new => feedback from Talend |
| 2007-10-19 10:20 | rbillerey | Assigned To | => rbillerey |
| 2007-10-19 10:20 | rbillerey | File Added: pivot.xls | |
| 2007-10-19 10:20 | rbillerey | generated language | => perl |
| 2007-10-19 11:13 | plegall | Summary | New component tPivotOutputCsv => New component tPivotOutputDelimited |
| 2007-10-22 10:08 | plegall | Relationship added | related to 0000985 |
| 2007-10-22 10:09 | plegall | Status | feedback from Talend => assigned |
| 2007-10-24 13:56 | rbillerey | Note Added: 0004829 | |
| 2007-10-24 14:07 | rbillerey | Status | assigned => resolved/needs doc |
| 2007-10-24 14:07 | rbillerey | Fixed in Version | => 2.3.0M1 |
| 2007-10-24 14:07 | rbillerey | Resolution | open => fixed |
| 2007-10-24 14:07 | rbillerey | Note Added: 0004830 | |
| 2007-11-22 09:22 | plegall | Status | resolved/needs doc => closed |
| 2007-11-29 11:43 | rbillerey | Relationship added | related to 0002553 |
| Mantis 1.1.6[^] Copyright © 2000 - 2007 Mantis Group |  |
