Forum Discussion
Solved
Match on cyclic data ascending and descending back
Hi I'm this weird problem occured to me and I'm curious, why is this happening and if there is any way how to solve it. I have cyclic data, i.g. it goes from 0 to 2 and back to 0 and I would like...
- Non-exact matches require the entire searched column to be sorted in ascending or descending order. Your data isn't sorted and hence you cannot do a non-exact match on all of the data
Basically, the result is not reliable if the lookup column is not sorted in ascending order.
Yep, that's a good way how to put it 😄