topic Using where syntax and select highest value per project in App Development

Using where syntax and select highest value per project

JohannesBoehmer — Thu, 10 Aug 2023 06:41:01 GMT

Hello,

I´ve a data model where I have a project ID and every project ID can have either one or more milstones reached.

For example:
P10999|PM040,PM070

P50002|PM070

P60232|PM040

Now I did the following: if(MILESTONE='PM040','1',if(MILESTONE='PM070','2','0')) as Milstone_Number. Now every PM040 has a 1 and every PM070 a 2.

Can someone help with the syntax in the where clause? I want to choose the highest value every Project ID has now.

Thank you!

MayilVahanan — Thu, 10 Aug 2023 06:52:11 GMT

Try like below, it will give only the max milestone info per project.

Inner Join
Load PID, max(Milstone_Number) as Milstone_Number Resident MTemp Group by PID;