You have a two options that I can think of:
-
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. -
From Dynamo 2.0, Dictionaries will be available so these kind of workflows will be heavily streamlined by querying
keys
instead ofindexes
. 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.