Working today found a issue where if you group by the same field twice it gives an incorrect result, replicated this with a simple example below. I also tried it on an older version (2021.4.2) and it does not happen there.
Inputs:
WHen goruping by one field, works as expected
When grouping by the same field twice, gives wrong result:
Version:
Thank you for the workflow, I misunderstood the issue.
I now see the additional records output when run with AMP. I will create a defect for this, but for now I tried it with "Engine Compatibility Mode" selected and it returns the same results.
@TonyaS Thanks for passing this on. I worked around this issue already for my workflow. Just wanting to help improve the AMP engine because I think it is a great addition. Just need to iron out all the issues so we can use it more often.
This will be fixed with the 2023.1 Release.
I’m happy to announce that the fix is released in the 2023.1 GA Release version May 17, 2023, which is available for download from our licensing portal.
It is also available in the next patches
2022.1.1 Patch 6 Release: Mar 29, 2023
2022.3.1 Patch 3 Release: May 5, 2023