You have a two options that I can think of:
-
Transpose the output from
Excel.ReadFromFilenode, 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
keysinstead 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.
