How to match family name with materials?

Revit
1

Hello,

I am trying to export some materials information to an Excel file. Here I can get the name, the density, the area and the volume of all the materials that are in the walls.

Excel1

But I can’t figure out how to get the family of the material. Here is what I would like to have in excel :

Excel2

Here is what my dynamo file looks like :

PNG
Dynamo_famille.PNG.jpg1270×790 273 KB

Thanks for your help

2

Your best bet is getting the name of the wall type from the starting All Elements of Category node and then using a List.Count @L2 against the Elements.GetMaterials. This will get you the count of how many materials are in each wall element, along with the wall type of this element.

Next, you can do List.OfRepeatedItem using the count and the wall type to get the wall type for each individual element. You can add this to the List.Create node.

All of this requires a lot of working with levels that you will probably have to play around with.

3

Thank you very much @kennyb6 ! I tried your solution and it works perfectly fine :slight_smile:

1 Like