Hi, suppose I have a multi-value field which represents names, which can have different values in each event. for example:
names (ordered by time desc): event 1: Emma, Dan, Mike event 2: Dan, Patrick event 3: Mike, Olivia
In addition, I have another multi-value field which represent the correspond people's grades (correspond by order):
grades (ordered by time desc): event 1: 80, 70, 100 event 2: 90, 75 event 3: 88, 95
I would like to take for each person his last grade (i.e take all the ever seen people without duplications). My result should look like:
Emma 80 Dan 70 Mike 100 Patrick 75 Olivia 95
... View more