# Manipulation between the records **URL:** \ **Category:** CloverDX Platform\ **Created:** [August 27, 2014, 12:00am UTC](https://forum.cloverdx.com/t/manipulation-between-the-records/1466 "2014-08-27T00:00:00Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![khurshid](https://avatars.discourse-cdn.com/v4/letter/k/e8c25b/32.png) [@khurshid](https://forum.cloverdx.com/u/khurshid)\ **Post date:** [August 27, 2014, 12:00am UTC](https://forum.cloverdx.com/t/manipulation-between-the-records/1466/1 "2014-08-27T00:00:00Z")
Hi, I have a stream of data where I want to do some manipulation based on the previous record. Ex: Record Date Required Available 1 12/08/2014 3 2 2 13/08/2014 4 5 3 14/08/2014 2 2 For every record, I need to search whether we have a record for previous day and if i have i need to put the summation values of required and shipped quantity in the newly created column. Illustration: Record Date Required Available SummationRequired SummationAvailable 1 12/08/2014 3 2 3 2 2 13/08/2014 4 5 **7 7** 3 14/08/2014 2 2 **6 7** Any pointers will be appreciated. Please let me know in case of questions. Thanks, Khurshid ---
**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:** [August 27, 2014, 1:30pm UTC](https://forum.cloverdx.com/t/manipulation-between-the-records/1466/2 "2014-08-27T13:30:07Z")
Hi Khurshid, You can store data of previous record/records in global variable. See sample [viewtopic.php?f=4&t=6913&p=11265&hilit=+global+variable+#p11265](http://forum.cloveretl.com/viewtopic.php?f=4&t=6913&p=11265&hilit=+global+variable+#p11265) for detail. I hope this helps. ---
**Author:** ![khurshid](https://avatars.discourse-cdn.com/v4/letter/k/e8c25b/32.png) [@khurshid](https://forum.cloverdx.com/u/khurshid)\ **Post date:** [September 3, 2014, 8:51am UTC](https://forum.cloverdx.com/t/manipulation-between-the-records/1466/3 "2014-09-03T08:51:24Z")
Thank you Jaroslav Kubos. That works 🙂