Set Material based on information from a data table

I work in construction and I just started to learn Unreal. I have the building model at my level. And I have the construction schedule as a data table in the content folder. Every item on that building (columns beams, etc.) has a reference as a mesh variable in the data table.

There is variable in the data table called status, which can take a value of (not started, in progress or completed).

What I am trying to achieve is how to set the material of a static mesh (building component) based on the status variable.

For example, if 1st-floor slab status is not started the material will be set to Silver, if it is in progress to set to Gold, and if it is completed to use the concrete material. Bearing in mind that I have different types of completed materials, such as blockwork, flooring, etc.

Thank you very much for your attention! Any tips will be highly appreciated!

Hey @SneakyPeeky71! Welcome to the forums! I love seeing people outside the gaming industry using our Engine!

You can simply use the “Set Material” node to set a material. If I knew more about how your setup works I could help further. But right now, all I can do is suggest the “Set Material” node :frowning:

1 Like

Thank you very mush for your reply. I work as a planning engineer and I am learning UE to develop a virtual model of our project to present the weekly progress of works to clients. One of the things I wanted to acheive is to link this model to an excel sheet (csv file) to update the progress automatically…

I have used the Datasmith plugin to import the building model form Revit.

Any furhter suggestions will be much appreciated.