List matching based on key values

#1

I am using Dynamo primarily to integrate external data into Revit. My external data source tables typically do not have the exact same data items as what I have in Revit, but always share a common key value. I was happy to find the “filter two lists by keys” node by @erfajo. Please see my first attempt at using this node and perhaps you might be able to tell why my filtered lists are coming back Null. I really appreciate your help!

Lists
Lists.png3012x1214 248 KB

Areas In From Excel Filtering.dyn (19.0 KB)
LAF_Employee_to_Rooms_Test.xlsx (8.4 KB)
Project1.rvt (1.6 MB)

#3

The solution is straight forward. You compare apples and pears… meaning you try to compare string and double values, that wont work… please see the solution.

Areas In From Excel Filtering.dyn (21.4 KB)

Capture
Capture.png3014x1304 262 KB

#4

Got it – thanks so much! Everything looks good and completes run, but parameters are not being written to Revit. Any thoughts? Thanks again!

#5

I froze the node…
and if it doesn’t write any value, is it then the right value you try to write to the parameter?
dont feed number values to string parameters

#6

Sorry, was rushing. I failed to convert the sorted element id list back to elements. All is good now - thanks again!

#7

You are welcome :slight_smile: