Hi all. I am new to Dynamo and am struggling with some list logic. I know there are lots of questions about lists out there, but I can’t seem to find a post with similar scenarios. Apologies if this is answered elsewhere.
I often find myself creating a lot of redundant series of nodes. Typically I am doing the following:
Read Excel File > Filter Excel Data into List A and List B > Perform a series of tasks on both lists, but slightly different. I end up creating duplicate series of nodes with one minor difference in each one. It just seems like there is a better way to do this.
For instance, in this graph I am taking Program Data from excel, then filtering for Level 1 and Level 2 spaces in order to place mass families on Level 1 and Level 2 respectively. I am first filtering out the levels, then placing masses. In turn, I end up completely duplicating the Level 1 “Place Mass” nodes in order to create Level 2. The slight difference is that for Level 2 I am translating them up (or in this case over), and then assigning their respective room names and departments at the end. Even if I were to do this repetitive task, what happens when I have Level 3, 4, 5, etc? Keep copying the series? How do I make it more dynamic so that my Excel data can change from 1 Level to 5 Levels without me adjusting the graph?
Another similar situation - I want to color the masses by department, but am struggling to find the best way to do so dynamically. Seems I have to know ahead of time if I have 2 departments or 5, and to place 2 to 5 separate “Set Parameter Value by Name” and “Material by Name” nodes. Also not sure how to filter by department after my masses are currently grouped into Levels. How do I separate them again to color by department, without having to repeat the same set of nodes at the end of each series (i.e. assign colors/materials to Depts X, Y, Z at the end of the Level 1 series, then assign colors/materials again to Depts X, Y, Z at the end of the Level 2 series).
Third scenario - if I want to place masses in order of size, and I sort my Area data (from Excel) according to size, how do I then match up and apply the Name, Department, etc values (from Excel) now that my list is out of order (because I sorted the Area). I think this has something to do with assigning and re-mapping key values to the Name and Department data?
If you make it this far, I am also struggling with getting the tagging to work. I seem to have the nodes set up correctly, and the tag is loaded into the project, but I don’t see any tags in the views I select.
Sample Graph, Excel Data, and Family used for placement attached.
Place Masses By Level_Sample.dyn (199.0 KB)
Program Data.xlsx (13.4 KB)
MSS-Program-SpaceType-Box-UH.rfa (400 KB)