Sort Array plugin

madhu · January 31, 2023, 9:42am

Hello Everyone,
Sort Array Plugin is not working properly, Can anyone help me with this.Please refer the screen shot

Darren_Murphy · January 31, 2023, 9:45am

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.

madhu · January 31, 2023, 9:47am

It’s a lookup

Darren_Murphy · January 31, 2023, 9:48am

A lookup on what?

Can you show me the configuration of that column please?

madhu · January 31, 2023, 9:51am

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

Darren_Murphy · January 31, 2023, 9:58am

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.

madhu · January 31, 2023, 10:09am

madhu · January 31, 2023, 10:13am

from this column I have fetched the total points

Darren_Murphy · January 31, 2023, 10:20am

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.

madhu · January 31, 2023, 10:48am

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

nathanaelb · January 31, 2023, 10:48am

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?

Jeff_Hager · January 31, 2023, 1:28pm

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.

Robert_Petitto · January 31, 2023, 1:37pm

Yes…I’m pretty sure the unique values converts values to text.

Darren_Murphy · January 31, 2023, 1:39pm

That’s it, Bob.
I just did a quick test and you’re absolutely right

Robert_Petitto · January 31, 2023, 1:41pm

I had that same issue when I was building my ranking logic.

gvalero · January 31, 2023, 1:52pm

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.

madhu · February 2, 2023, 6:15am

Thank You all for your time and support, it worked.

Darren_Murphy · February 2, 2023, 7:00am

@glide do not reply to this topic again.

glide · February 2, 2023, 7:00am

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.

glide · February 2, 2023, 4:00pm

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.