Hello Everyone,
Sort Array Plugin is not working properly, Can anyone help me with this.Please refer the screen shot
How are you creating the array?
I know that the Sort Array behaves differently depending on how the array is created.
If it’s a result of a join + split, then the resultant sort is lexical.
If it’s a direct lookup on a number column, then the sort is numerical.
It’s a lookup
A lookup on what?
Can you show me the configuration of that column please?
credits column is lookup from other table, on credits column I am using unique elements plugin to get unique elements and sorting these unique elements
Please show me the configuration of the Credits Array column, as well as the data in the table that it references.
My hunch is that somewhere in the chain you have data that is non-numeric.
So the Credits Array column shown in your very first screen shot is a lookup on the Total Credits column shown in your last screen shot, yes?
Please confirm the above. If that’s correct, then I can’t explain the behaviour.
Credits array is lookup of credits column of the same table(data helper) credits column is the lookup total Points column in champion table, that total points column in turn lookup of Total credits column of UserLogin Table
these screenshots are sequentially arranged
Your Relation_UserLogin and Relation_Champion relations: in both of these relations are both the source and destination columns numerical values?
You’re navigating through relations and lookups, and somewhere along the way you seem to be bringing in a lexical value. Is it possible that one of your columns is a basic text when you meant to set it as a basic number?
1 Like
If you have confirmed to the best of your knowledge that those numeric values have remained numeric as they have passed from column to column, then one of the plugins may still be converting them to text. I would try moving your sort higher up the chain. Maybe Sort BEFORE you get Unique values.
3 Likes
Yes…I’m pretty sure the unique values converts values to text.
6 Likes
That’s it, Bob.
I just did a quick test and you’re absolutely right 
5 Likes
I had that same issue when I was building my ranking logic.
That’s correct!
the workaround for @madhu is to change the order of procedure, I mean:
- Create your array
- Sort the array
- Use Unique Element plugin with sorted array
Saludos.
3 Likes
Thank You all for your time and support, it worked.
1 Like
This is an experimental reply from a bot. Please like it if it’s correct.
We apologize for any inconvenience caused. We understand that you may not want to receive replies to this topic, and we will respect your wishes.
3 Likes
This is an experimental reply from a bot. Please like it if it’s correct.
Yes, that is correct. Please reach out to our customer support team at support@glideapps.com and we’ll be happy to help you troubleshoot the issue.