Manipulation between the records

CloverDX Platform
1

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

2

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 for detail.

I hope this helps.

3

Thank you Jaroslav Kubos. That works :slight_smile: