Bumblebee - Search Value Get Row

Packages
1

Hey all,

I’m attempting to use the Search Value Get Row node from Bumblebee, and it’s returning an empty list. See below for the Excel snippet as well as my Dynamo script.

image
image.png1736×569 121 KB

image
image.png423×840 13.5 KB

As you can see, the text in the List.Sort output does match the text in the first column, so why the Empty List?

EDIT: I saw another thread that is asking me to keep the Excel file open – would it be possible to run this node without keeping the excel file open? I’d like to have my model open and run this via pulling the excel file from a server.

Any help would be appreciated! @Konrad_K_Sobon

2

Strange. I couldn’t get it to work either. Fortunately, you can write a quick codeblock to do the same thing.

mask=DSCore.List.ContainsItem(data@-2<1>,search);
DSCore.List.FilterByBoolMask(1…Count(data),mask)[“in”];

image
image1222×469 29.3 KB

1 Like
3

Thank you for the response, Nick! My code block doesn’t appear to read the data like yours, perhaps it’s because my input is in the form of nested lists.

I have fairly nonexistent knowledge of Python, so maybe it just takes a few tweaks of the code in the code block?

image
image.png1235×695 124 KB

4

Are you reading from multiple Excel files?
You should be able to change the first line to data@@-2<1> to preserve the list structure. It should still work though.

image
image.png571×594 18.7 KB

5

Nada, Just one Excel file. I did the @@ and it came up with this:

image
image.png1116×474 32.1 KB

6

See if it works with just one search item.

This is what I had to use to get it to work with multiple data lists and multiple search items.

mask=DSCore.List.ContainsItem(data@@-2<1>,search);
mask2=DSCore.List.Transpose(mask@-3<1>);
out = DSCore.List.FilterByBoolMask(data@-3<1>,mask2@-2<1L>);
__TryGetValueFromNestedDictionaries(out,"in");
7

Same error – only fed one input, still an empty list.

image
image.png1883×829 164 KB

8

Do you have any rows with “A” in them? List.ContainsItem requires an exact match. Partials will not pass.

If you’re able to post your Excel file I can dig into it further.

9

Ahh! I misunderstood what it was searching for. I figured the input was the column name (my fault).

It works perfectly (the second, 4-line code). Thank you Nick!!

1 Like