Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
A combination of tMySQLInput (with order by criteria) and tAggregateSortedRow components together. Make sure you correctly set the "Input Rows Count" which means you'll probably need to read the data into an intermediate file.
tCreateTemporaryFile
|
tMySQLINput -> tFileOutputDelimited
|
tFileInputDelimted -> tAggregateSortedRow -> (whatever you want to do with the aggregated data)
Thanks
David