Startet working with dynamo few weeks ago and have my first question because i cant find a solution myself.
I have an Excel Sheet from a Database that will change over time. There are 3 Values in each row of the Excel Sheet (Article Number, Article Name & Weigt). I imported the Excel sheet and get a List with ~5400 Lists in it. Each of this ~5400 lists contain the 3 values that i mentioned above.
Now the thing i need to do is to write these 3 values in a Family. I know the way how to write a parameter in a Family, i only need the way to filter the list that i only get the 3 Values that i need out of these 5400 x 3 values.
The following Picture shows my current node for the import of the Excel sheet:
I want to have now only the List that contains 3 values with the Index 3328 for this specific part. The only way I found is to use “List.GetItemAtIndex”.
Basically this works fine and i get the 3 values that i want and can write them in my family, the problem is that the Index can change everyday for example when we get a new item in our Database (Then the index would be for example 3329).
The only thing that stays always the same is the Article Number which is 586536000 in this case and marked yellow in the picture.
Is there a way to get this list with the 3 Values (586536000, Dokadek Wall Head & 4,33) by filtering with the Articlenumber that is in this list`?