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
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
-
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. -
Thank you Jaroslav Kubos. That works :)
Please sign in to leave a comment.
Comments 2