I want to match two lists One gives me information about a component, out of a geometry, the second list is out of a schedule from revit. Is there a way if I can combine those two lists and sort them together?
Example: get door ID, Name from geometry and ToRoom from the door schedule.
123456, DoorA, belongs to Room25.
I checked already how to match lists, only with code blocks, are there any other possibilities without using them?
thanks.
Finally I found a solution for correct sorting my list.
My problem was to create a list with to from room, with including or listing all 0 rooms (so not defined rooms).
I used a python script, and replaced all non-defined with a Code Block “no room defined”
After creating a Excel List, I would like to make an export from Excel to CSV, in one workflow if possible.
I know there are possibilities to get external links and convert them to csv, but can i get directly, after creating a list, say something like file write to csv and export it to a csv file?
what i found out … separate the scripts and get the excel file again in and creating a csv out of it.
maybe anyone can see where i am struggeling right now… he doesn´t do anything for file write to csv …
there I made a query for doors, get category, ask with a python script for the width in order to figure out if doors are bigger than 900 or not. further I translated it to CSV.