If I want to group by these data and make group with FirstName and Lastname and I want to find the product bought at the most recent date of payment, how would i do ?
( i mean a result tab like this : )
Paul
Sirk
Guild wars 2
09/12/2020
Florent
Polo
World of Warcraft
08/09/2019
I was thinking about
Firstname,
Lastname,
max(Date of payment)
Group by Firstname, Lastname ?
But to have the product bought of the max date of payment how to do ? Is it forced to do a sort by before ?
table1: load * inline [ FirstName LastName "Product bought" "Date of payment" Paul Sirk "World of Warcaft" 02/07/2019 Paul Sirk "Guild wars 2" 09/12/2020 Florent Polo Flyff 01/02/2017 Florent Polo "World of Warcraft" 08/09/2019 ] (delimiter is spaces) ;
table2: LOAD FirstName, LastName, FirstSortedValue("Product bought", -"Date of payment") as Product, Date(Max("Date of payment")) as "Date of payment" RESIDENT table1 GROUP BY FirstName, LastName ;
table1: load * inline [ FirstName LastName "Product bought" "Date of payment" Paul Sirk "World of Warcaft" 02/07/2019 Paul Sirk "Guild wars 2" 09/12/2020 Florent Polo Flyff 01/02/2017 Florent Polo "World of Warcraft" 08/09/2019 ] (delimiter is spaces) ;
table2: LOAD FirstName, LastName, FirstSortedValue("Product bought", -"Date of payment") as Product, Date(Max("Date of payment")) as "Date of payment" RESIDENT table1 GROUP BY FirstName, LastName ;
