Forum Discussion
Group by Max
You are not grouping by ONLY the Phase _ID, though. Your code says you are grouping by several other columns as well, so your grouping will return the combination of unique values of the fields you selected to group.
If you have a list of the 12 months, with each month having 30 rows for the date. If you group by month ONLY, you will get 12 unique rows. If you group by month and date, you will get 30 groups for each month. If you need to have no duplicates, group ONLY on Phasen_ID, and add an "All Rows" aggregation. You can still do your List.Max as well. Any other values you might need are in the nested tables.
--Nate
You would still Group by Project, and then choose the aggregation Max for the Phazen column. Use the Group By GUI dialog.
--Nate
I could solve it with table.buffer, sort descending and then remove duplicates. 👍
You are not grouping by ONLY the Phase _ID, though. Your code says you are grouping by several other columns as well, so your grouping will return the combination of unique values of the fields you selected to group.
If you have a list of the 12 months, with each month having 30 rows for the date. If you group by month ONLY, you will get 12 unique rows. If you group by month and date, you will get 30 groups for each month. If you need to have no duplicates, group ONLY on Phasen_ID, and add an "All Rows" aggregation. You can still do your List.Max as well. Any other values you might need are in the nested tables.
--Nate
You would still Group by Project, and then choose the aggregation Max for the Phazen column. Use the Group By GUI dialog.
--Nate
I could solve it with table.buffer, sort descending and then remove duplicates. 👍