Find Maximum of a subset

Luqlik — Fri, 03 Mar 2023 14:19:21 GMT

Hello everyone,

I bet you can help me with this one!

In my app, I access the following table from a database:

BookingID	Booking Date
1	29.01.2020
1	02.02.2015
1	05.01.2021
2	01.01.1993
2	03.02.2020
3	01.02.2021
3	04.02.2020
3	07.03.2020
3	02.01.2020

I now want to add a new column that indicates which booking record for a Booking ID has the latest BookingDate.

Example:

BookingID 1 exists 3 times. The highest BookingDate for BookingID 1 is in row 3. This is to be indexed in a newly added column.

Like this

BookingID	Booking Date	Latest Booking Date of BookingID?
1	29.01.2020	no
1	02.02.2015	no
1	05.01.2021	yes
2	01.01.1993	no
2	03.02.2020	yes
3	01.02.2021	yes
3	04.02.2020	no
3	07.03.2020	no
3	02.01.2020	no

How can I implement this as uncomplicated as possible?

Please excuse my beginner question, but I am not that experienced yet.

Many thanks in advance.

Luqlik

Translated with www.DeepL.com/Translator (free version)

Re: Find Maximum of a subset

rubenmarin — Sat, 04 Mar 2023 08:14:28 GMT

Hi, an easy way could be adding a field in scripts, just load the data from the most recent by booking id and the first of each BookingId will be the last, like:

tmpBaseData: LOAD BookingID, [Booking Date] from ...; FinalData: LOAD BookingID, [Booking Date] If(BookingID=Peek(BookingID),'no,'yes') as isLatestookingID Resident tmpBaseData Order By BookingID, [Booking Date] desc; DROP Table tmpBaseData;

topic Re: Find Maximum of a subset in App Development

Find Maximum of a subset

Re: Find Maximum of a subset