Dictionary.ByKeyValues issue!

Lists-Logic
1

I’m trying to import some data from excel using the Dictionary.ByKeyValues node. I noticed that when I use a list of search keys, it returns null values but when I use a single string…it’s successful. I’d appreciate any ideas.
list

2

Single string

3

@okarim6RZ7U - can you try the out-of-the-box dictionary nodes instead?

4

Should it matter though? I had used the same node earlier for another graph…just different excel files. It worked.

5

I don’t use the out-of-box version. The springs version is much more simple to use.

Never had an issue with this node…Can you maybe show the inputs to the keys and values as well?

Cheers,
Matt

6

keys and values
keys and values773×598 44 KB

The keys and values match, so that shouldn’t be the issue too.

7

image
image773×598 43.4 KB

…just showing the corresponding list item index in this image that I need.

8

But you are feeding it nulls…

Keys need to be unique values.

1 Like
9

I removed the null values but still the same issue.

10

Key’s also need to be a string, so can you chek with an Object.Type node and a List.UniqueItems node to ensure they are all strings?

11

Yes, but the keys still need to be unique values.

Maybe if you group by key, and then do a list count, you can see fi you have duplicate values.

1 Like