Hi,
I have a scenario in which I have to copy latitude longitude values of a credit card, from a previous record having latitude longitude values present in it.
The record has following parameters:- credit card number,Status id, Latiutude, Longitude, Timestamp.
The values should be copied only if "status id" of current record is 10 and "latitude" "longitude" values are not present.
In such case the latitude and longitude values of previous record, having same credit card number, which occurred 1 hour before the current record, should be copied to the latitude longitude values of the current record.
Please guide me on how could this be implemented.
... View more