Is it possible to sort sub-lists without affecting the previous sorting of the list structure?
In the example below I have collected the floor finish elements and extracted the room name, room number (populated using RIE.Point.SpaceAndRoom Node) floor finish area, floor finish description, specification clause and floor finish colour. Some rooms have a single floor finish while some have multiple floor finishes.
After creating a list of the collected data and using List.Transpose I have each floor element with 6 values, I have then grouped and sorted the list by room number to give a list of rooms at level 3 and the floor finishes for the given room at level 2 which is the list format I would like to maintain.
What I would like to do now is sort the list at level 2 (floor finishes per room) by the floor area for the rooms with multiple floor finishes to give the primary (largest) floor finish at index 0 at level 1, secondary floor finish at index 1 at level 1 etc… All of my attempts thus far are rearranging the original list structure. Is this possible?
Any help would be much appreciated!