Filter a specific row from excel

Lists-Logic
#1

Hallo everyone,

I got an excel sheet and try to get coordinates from it. The problem is to mark every point like the “100” with an individual family.
x y z number
1 1 0 100
1 2 0 100
1 4 0 100
2 1 0 300
2 2 0 300

That is for example why I am trying to filter the 100 and get only the rows with their coordinates

grafik
grafik.png1473×535 216 KB

I can filter the numbers but will not get their coordinates to bind them to a familyinstance

Sorry my english isn´t the best but I hope you will get my problem

#2

Hi :slight_smile:

Instead of connecting your last row to the list input of List.FilterByBoolMask, why not connecting your coordinates ? I think that should do the trick.

If this does not work, you can also use List.IndexOf in conjunction with List.GetItemAtIndex.

#3

grafik
grafik.png1517×635 277 KB

#4

Hey mellouze,

did not expected you are this fast. Thank you so much, what an easy sollution :smiley:
Is there a way to do the marked code without using clockwork package?

grafik
grafik.png1370×707 312 KB

#5

You can double click on the node and copy/paste its content in your graph, but, unless you are 100% sure on what it does, I would recommend keeping the custom node. The nodes of custom packages can be frequently updated (even when Dynamo itselfs or Revit updates).