Forum Discussion
Remove duplicates based on multiple criteria
and try this
Thanks a lot!
You just solved my problem. Appreciate it 🙂
to know how to do this watch my video
Thanks for this!
However there is still a problem. This was also one of my original sollutions.
In the batch ending with 7021 i have the values 8 and 3.
With your example the value to be kept is 3, but this is outside the tolerances. I need 8 to be the value to be kept in this case.
I added another two lines to specify what i need:
In this case, i want the row with the value 4 because it is closest to the tolerances. With your example it will give me 2.
Does it make sense?ok, pls try again
(x)=> if List.Max(x[Result]) > List.Max(x[Lower tolerance]) then List.Min(x[Result]) else List.Max(x[Result])Thanks once again!
You are so close to make it right.
Unfortunately the batches ending on 7021 and 1021 gives me the number 3 in both cases.
I need in only these two cases to get the number 8 and 6.
The reason is, that the result min is outside the tolerance and i therefore need the highest numbers, because it is within the tolerances.
Additional info:
Also if, lets say i have a result above the tolerance and another beyond the tolerance, i need the result closest to the tolerance gap to be kept.
For example:
Here i need 4 and 11 to be kept.
Hope you can make it? 🙂