Sort all lists based on a column of one list

[Andreas Pfeiffer]

Hi Massimo,

What do you mean with “based on the 2nd column of ivList1”?

Do you mean a value from ivList1 and if so, in which line? Is there any current line set?

Best,

Andreas

[maxperique]

Hi Andreas.

Something like the attached example.

ivList1 is sorted based on $ref.C2 and so does ivList2: it is sorted based on ivList1.C2, as if they were a single list…

[Andreas Pfeiffer]

Massimo,

Do I understand this correctly that you want to sort all lists in that instance the same column in one go?

Assuming that all those lists are instance variables of the current instance you could do something like this:

Do $cinst.$ivars.$sendall($ref.$sort($sendallref.c2),$ref.$type=kList)

So basically you would send a message to all members of the $ivars group in the current instance that are of type list to do a sort on column 2 (c2).

Does that help?

Best regards,

Andreas

[maxperique]

Hi Andreas.

This command will sort all lists based on the 2nd column of each list. So the 2nd list in the example would be A,B,C instead of B,C,A

I’d need instead something like this

Do $cinst.$ivars.$sendall($ref.$sort(ivList1.C2),$ref.$type=kList)

The fastest way to do it, that I found so far, is to add ivList1.COL1 to ivList2 (with another column name, e.g. TEMP), do ivList2.$sort($ref.TEMP) and finally remove it ivList2.$cols.$remove(ivList2.$colcount)

• This reply was modified 2 days, 17 hours ago by  maxperique.