Reputation: 127
We are trying out talend and we wanted to aggregate some sorted data on few keys . Simple enough but when we try to use taggregatesortedrow its asking for Exact number of rows to be specified. I am not sure how any one can input this on the fly. Dosen't this value change for every run ? am i missing something. surely they cant expect us to know total recs before we run the job.
Upvotes: 1
Views: 663
Reputation: 8239
This has to do with the way in how the Talend component tAggregateSortedRow is programmed. To avoid it omitting data you need to provide the record count. There are a few users with the same question like you asked:
which I found simply by using Google.
Anyway, if you need to do sorting and aggregating, consider using the components tAggregateRow and tSortedRow separately. It should work fine.
Upvotes: 2