Hey community, I am trying to add information from excel to revit using dynamo. However, I got stuck and could not figure out the way out. Case: I am trying to look if object parameter “CCSSingleLevelID” matches data in column C, if it does the value from column A in the same row should be returne…

@pbagdo16 Did you try to wire your Watch node to the “a[k];” output? It should return the correct result :smirk: Here is also a example for anyone interested.

Hey mate, I think you have runned into a similar issue I had short time ago, you want to compare two lists and find out the matching ones and assing a value according to it. here is the post were my issue was solved, hope it can help: (I will try to test it with your data, no promises I will achie…

Thank you for the response, however, your issue was slightly different and I cannot work around it to help to solve mine. Thanks for the input anyway!

The issue is with the code block: a[i]=j; a[k]; There is no comparison there - you are just reassigning the data in list a at index i to be the value j. I assume you’re trying to compare List K (your parameter values from the Revit model), to the values in List I (the excel data with data that st…

Thanks for the reply. You understand my case correctly. However, your methods seems plausible, but I am not really sure how to execute it, hopefully you can find time to present it. Data set is not large yet, I intend to do this for way larger model, therefore the most optimal solution would be ap…

Thank you! I definitely need to learn Python, which seems can solve anything with a good understanding.

@Yna_Db You are totally correct. I was following exactly the same thread from the beginning, but totally missed that the output is from a[i]=j… It means that the thought was correct, just the execution was failed in the last step. @Yna_Db your solution is way easier than @erfajo , but anyway both s…

This post has helped me immensely so thank you to all contributors in advance. One additional question, Is it possible to expand on this idea and have multiple values from excel report back to different element fields in Revit? If so, what would that look like? See my markup of a previously posted …

Index if values matches

Yna_Db November 27, 2017, 4:52pm 10

@pbagdo16
Did you try to wire your Watch node to the “a[k];” output? It should return the correct result
Here is also a example for anyone interested.

Topic		Replies	Views
Compare Revit element parameter values with Excel list values Revit revit , excel	10	3328	October 19, 2017
Read Excel data in dynamo Revit revit , excel , dynamo	6	456	November 2, 2020
How to validate parameters from Revit against a set of allowed values coming from an Excel Revit	3	65	March 26, 2026
Compare a value from Revit with All cells in a MS Excel Revit	9	664	April 20, 2021
Export select information from excel to family parameters of revit Packages revit , excel , dynamo	20	2444	June 21, 2018

Index if values matches

Related topics