Filter Rooms from linked model by room numbers from excel sheet

Dynamo Player
1

HI everyone I have a problem which i really need help with. the thing is I have a sheet excel contains rooms Numbers and Names which like 175 room. In the other hand I have the linked model which has 940 rooms. I want to select these rooms 175 from the linked model. And i don’t know how to filter. thanks alot

ASK
ASK1013×828 129 KB

2

Hello!

If both the lists contains strings you can easily use the node List.Contains to get a boolean list.
After that you can use the node List.FilterByBoolMask to get the elements with the obtained boolean list.

Hope it helps!

image
image1223×578 39.3 KB

image
image1216×513 38.9 KB

3

No. that is the thing the rooms from linked model is model elements and the data from excel is strings. that is the tricky part i guess. I need to select the rooms (model elements) based on the strings which in relies in the excel sheet. @diogoo21

4

ok, understand! you can use the list.contains with the room number (“string”) and the use the list of elements “rooms” in the list.filterbybool.

image
image1254×588 45.9 KB

1 Like
5

Nice it worked thank you. :slight_smile: @diogoo21. I went far away while the solution is simple.

1 Like