Hello wizards, I am hoping someone can point me in an easier direction. I have a list of elevation values and am ultimately trying to find columns which are above and below the list of values. I have developed a code block which works completely fine, but i am hoping someone can give me something far easier and not so cumbersome. I am using the code block to filter the columns which apply to the above parameters. Instead of having to mask each level, i would like a method to feed in the entire list of “elevations adjusted” and compare to the entire lists of “actual top elevations” and actual base elevations" and then provided me one list with all columns sorted by level. Does anyone have any insight?
List.GroupByKey can work here - just adjust your values to what you need. You can then include exclude using FilterByBoolMask
This method is just gathering columns at level start elevations unless i am missing something? If i have columns running 3-4 stories or more, and sometimes starting,stopping, moving etc at different levels. I want to find which columns run continuous through a list of elevations and group accordingly.
You’re definitely going to want to figure this out with lists. You do not want to deal with each of these conditions separately.
I think I’d deal with the upper and lower bounds separately at first. Get them for each column and then determine where the range falls - you can probably do this with a value comparison. It’s still a little confusing as to what you’re actually trying to accomplish, but if you’re building each list for each level then you might be able to check each elevation individually since that’s all you need to determine inclusion.
1 Like
I have top point and bottom points, those are my max and min numbers being inputted. I will try to do my best to explain my intent as an example. If i have 5 columns (A) going from 0 at bottom to 10 at top, 2 columns (B) going from 0 to 7 and 2 columns (C) going from 7 to 10 (total of 9 columns). I have level elevations at 1,3,6,8. What i want to gather is how many columns have points both above and below those elevations at each level.
So at Elevation 1 - i would get columns A,B
Elevation 3 - i would get columns A,B
Elevation 6 - i would get columns A,B
Elevation 8 - i would get columns A,C
I am hoping this makes sense. I was trying to get away with just using number values, but i may have to get boundingboxes involved in accomplish it.
I’d check column bottoms and column tops against level elevations separately. You should have true for columns below a given level and false if equal to or above. Same thing for above the given levels. Then you can check to see for each column whether both conditions are true at each level. If both conditions are true, then the column “spans” that level.
This works perfectly. For some reason i thought going that route would be too cumbersome when it came to filtering nicely but i was clearly wrong. Thank you!