Filter List by Element that is in a List of this List

You have a two options that I can think of:

  1. Transpose the output from Excel.ReadFromFile node, which will result on 3 lists. Search for the index of the desired output on the first list and get the parameters desired from the other two list using that index.

  2. From Dynamo 2.0, Dictionaries will be available so these kind of workflows will be heavily streamlined by querying keys instead of indexes. Until it is released, there is the JsonData package which behaves similarly and provides extra functionalities, like filtering by key and value.


filterListByValueOfNestedList.dyn (17.2 KB)

EDIT: If there is a chance that the value searched for is not on the data, this exception should be handled properly.

1 Like