# Aggregate many records not using aggregation function

**URL:** <https://forum.cloverdx.com/t/aggregate-many-records-not-using-aggregation-function/1350>\
**Category:** CloverDX Platform\
**Created:** [February 12, 2014, 12:00am UTC](https://forum.cloverdx.com/t/aggregate-many-records-not-using-aggregation-function/1350 "2014-02-12T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bobirving](https://avatars.discourse-cdn.com/v4/letter/b/9e8a1a/32.png) [@bobirving](https://forum.cloverdx.com/u/bobirving)\
**Post date:** [February 12, 2014, 12:00am UTC](https://forum.cloverdx.com/t/aggregate-many-records-not-using-aggregation-function/1350/1 "2014-02-12T00:00:00Z")

</div>

I have data files which consist of samples from a datalogger, which creates one record every half hour (or similar) with temperature readings. I need to aggregate the 48 half hourly records for one day into a single record for the day with 48 temperature values. Is there a way to get an Aggregate transformer to do this, please? Or any other way?  
TIA  
Bob irving

---

<div class="post-metadata">

**Author:** ![David\_Hlidek](https://avatars.discourse-cdn.com/v4/letter/d/58f4c7/32.png) [@David\_Hlidek](https://forum.cloverdx.com/u/David_Hlidek)\
**Post date:** [February 13, 2014, 9:04am UTC](https://forum.cloverdx.com/t/aggregate-many-records-not-using-aggregation-function/1350/2 "2014-02-13T09:04:12Z")

</div>

Hi Bob,

I would recommend to use [http://doc.cloveretl.com/documentation/ … lizer.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/denormalizer.html)

\* add “measurement\_day” field into input record  
\* sort input data by “measurement\_day” field  
\* set “Key” property of Denormalizer to “measurement\_day” field (this ensures only records of same day are processed together)  
\* prepare output data so it contains field “temperatures” of type List ([http://doc.cloveretl.com/documentation/ … ields.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/multivalue-fields.html))  
\* in Denormalizer transformation just fill data into list using CTL2 functions - see [http://doc.cloveretl.com/documentation/ … -ctl2.html](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/container-functions-ctl2.html)

Other possibility is to use String for “temperatures” instead of List and store data as comma separated values.

I hope this helps.