Hi everyone, this is my first post so sorry if this is a simple question.
I am trying to export a list of elements from a linked file to Excel. I need to export the Element ID, Room Name, and Room Number as columns. I am able to retrieve the information I need, but I am having trouble formatting it for the Excel export.
My problem is there can be several elements in a single room, and they are being listed one level below the room number and names. For example, room NE106, Conference Room, has 6 elements in it.
I would like to repeat NE106 and Conference room 6 times so there is one line for each element ID when exported to Excel. I am thinking of this like a one-to-many join in a database. Please let me know if you have any suggestions!
Edit: version with node previews