Mapping for time-series data
Alind ·
Lecture 13
· a minute ago
Hi,
I am trying to create a mapping where intent is to record events for a user and aggregate them based on any given condition,
for example
a user can have
id -1 ,name - Sarah James ,status-Single ,address- ccc,xxxx,date- 01/01/1900
with time it can change to( Status,name and address changed)
id-1 ,name -Sarah James Smith, Status -Married,address- aaa,bbb,date - 01/06/1900
and than again change to (address changed)
id-1 ,name -Sarah James Smith, Status -Married,address- ppp,qqq,date-02/01/1903
At the same time,I also intend to record every purchase event of the user,
id- 1 ,name - Sarah James, Bought:4 wheeler,date -01/01/1900
id- 1 ,name - Sarah James Smith, Bought: Vacuum Cleaner,date -01/01/1901
id- 1 ,name - Sarah James Smith, Bought: Personal Computer,date -01/10/1901
id- 1 ,name - Sarah James Smith, Bought: House,date -01/01/1903
The use case is that I intend to aggregate the purchase history of a user based on time and map it to same id when the purchaser's name is different .