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!


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)


#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: